Forum Discussion
Solved
getting data from sheets that don't exist yet
I'm making an excel sheet for work to total invoice costs, and i have it all pooling to a master sheet. what i would like to be able to do is have the master sheet setup in such a way that it can aut...
Hi Bakuscout
you could place the name of an existing sheet in one cell and use in all your formulas the INDIRECT function with a reference to that cell.
In my screenshot, you but "Sheet2" in cell B1 and the formula in B3 is working fine, because Sheet2 exists already.
When you later get the real sheet name, just replace the name in cell B1:
Hi Bakuscout
you could place the name of an existing sheet in one cell and use in all your formulas the INDIRECT function with a reference to that cell.
In my screenshot, you but "Sheet2" in cell B1 and the formula in B3 is working fine, because Sheet2 exists already.
When you later get the real sheet name, just replace the name in cell B1: