Changing References in Main Sheet Formulas to Reflect Different Sheets Automatically

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3170200%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EChanging%20References%20in%20Main%20Sheet%20Formulas%20to%20Reflect%20Different%20Sheets%20Automatically%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3170200%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EMy%20master%20sheet%20contains%20a%20condensed%20budgetary%20tracking%20log%2C%20pulling%20data%20from%20various%20budget%20sheets.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECurrently%2C%20the%20section%20%22Concrete%22%20shown%20in%20yellow%20contains%20a%20series%20of%20conditions%20tied%20to%20various%20cells%20%26amp%3B%20equations%20in%20the%20%22Concrete%22%20tab.%20I%20would%20like%20to%20copy%20all%20of%20the%20formulas%20in%20the%20yellow%20section%2C%20and%20apply%20them%20to%20all%20the%20sections%20in%20green%20so%20that%20each%20sheet%20infills%20the%20correct%2C%20corresponding%20data%20into%20my%20table%20for%20it's%20appropriately%20labeled%20section.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMy%20problem%20and%20question%20is%2C%20how%20do%20I%20change%20the%20reference%20for%20each%20cell%20without%20having%20to%20do%20so%20manually%3F%20Is%20there%20a%20way%20to%20automatically%20change%20the%20sheet%20reference%20from%20%22Concrete%22%20to%20%22Structural%20Steel%22%20without%20individually%20plugging%20it%20into%20every%20single%20formula%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348465iD3D71BA95B8620D4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22YurHucklebarry_0-1644959754868.png%22%20alt%3D%22%5C%26quot%3BYurHucklebarry_0-1644959754868.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3170200%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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 various cells & equations in the "Concrete" tab. I would like to copy all of the formulas in the yellow section, and apply them to all the sections in green so that each sheet infills the correct, corresponding data into my table for it's appropriately labeled section.

 

My problem and question is, how do I change the reference for each cell without having to do so manually? Is there a way to automatically change the sheet reference from "Concrete" to "Structural Steel" without individually plugging it into every single formula?

 

YurHucklebarry_0-1644959900532.png

 

 

1 Reply

Hi @YurHucklebarry 

 

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.