SOLVED

getting data from sheets that don't exist yet

Visitor

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 automatically pull new data from the sheet that may be created in the future, without having to do all the formulas manually when i make the new sheet

1 Reply
best response confirmed by Bakuscout (Visitor)
Solution

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.

Martin_Weiss_0-1665558568778.png

 

When you later get the real sheet name, just replace the name in cell B1:

Martin_Weiss_1-1665558656066.png