I am keeping track of some training hours. I have a spreadsheet for every week. At the end of the workbook, I have a sheet that is keeping track of all the totals. But when I add a new sheet before the totals sheet, I have to update the formula to include the new sheet. Is there a way where I can have the formula automatically update when I add in a new sheet? That way I don't have to go and update the formula manually all the time.
The attached is just an example of what I am really doing.
@bldragon41
Just add two hidden sheets, for instance "First" and "Last". One just before Sheet01 and one just before the Totals sheet. Then change the 3D formulas to something like this:
=SUM('First:Last'!B40)
As long as you insert new sheets between First and Last, their totals will be included in the SUM.
Thank you. Is there a way to actually hide the sheets or would they have to be visible all the time?
I got it figured out. Thank you so much for your help!