Forum Discussion
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...
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
Your formula didn't return any data on any of the other sheets