Forum Discussion
Changing References in Main Sheet Formulas to Reflect Different Sheets Automatically
My master sheet contains a condensed budgetary tracking log, pulling data from various budget sheets. Currently, the section "Concrete" shown in yellow contains a series of conditions tied to var...
theoretically, this is possible with the INDIRECT-function. But due to the structure of you sheet it would things make more complicated.
I propose to really just copy the formulas and do a find & replace on the sheet name.