Forum Discussion

marietuttle1973's avatar
marietuttle1973
Brass Contributor
Dec 17, 2024

Help with formula in Exc

I have a spreadsheet with multiple tabs at the bottom.  On the Master I have one column with drop down list.  I want the info on the master tab to feed over to the tab corresponding to the tab that m...
Formulas and Functions
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Dec 17, 2024

The "Type" column from master sheet must be match with the other sheet's name,

Then, use mid and cell function to extract your sheet names, and use filter to return dynamically the data from master sheet, and will update whenever you input more data on the master sheet.

Put this formula to cell A2 of the other sheets. =FILTER(Master!A2:H15,Master!B2:B15=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),"No data")

 

m_tarler's avatar
m_tarler
Bronze Contributor
Dec 18, 2024

I would only note that the formula CELL doesn't work on Excel online or certain other platforms so if compatibility is needed I would suggest just inserting a row at the top and then in Cell A1 put the sheet name and then adapt the above formula to just look at cell $A$1 for the sheetname

Then on the Master you can automatically generate those sheetnames for your data validation using 

=VSTACK('Lead:Service Call Form'!A1)

see attached

 

  • marietuttle1973's avatar
    marietuttle1973
    Brass Contributor
    Dec 19, 2024

    Your formula didn't return any data on any of the other sheets

Resources