Set a cell equal to the formula in another cell and not its value

%3CLINGO-SUB%20id%3D%22lingo-sub-1250284%22%20slang%3D%22en-US%22%3ESet%20a%20cell%20equal%20to%20the%20formula%20in%20another%20cell%20and%20not%20its%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250284%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20the%20following%20issue%3A%3C%2FP%3E%3CP%3EI%20have%20a%20file%20with%20numerous%20sheets%20with%20the%20same%20data%20columns%20(different%20data).%3CBR%20%2F%3EThe%20final%20column%20is%20a%20formula%20column%20using%20the%20actual%20sheet's%20data%20for%20the%20calculation.%20Currently%20I%20will%20write%20the%20formula%20in%20the%20first%20sheet%20and%20then%20manually%20copy%20the%20formulas%20into%20the%20other%20sheets%20(very%20time%20consuming).%20Is%20it%20possible%20to%20set%20the%20columns%20in%20the%20remaining%20sheets%20equal%20to%20the%20formula%20in%20the%20first%20sheet%20so%20that%20if%20I%20change%20the%20formula%20it%20changes%20in%20all%20the%20sheets%20and%20I%20will%20not%20need%20to%20copy%20it%20every%20time%20manually%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1250284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250394%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20cell%20equal%20to%20the%20formula%20in%20another%20cell%20and%20not%20its%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250394%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F593346%22%20target%3D%22_blank%22%3E%40Herman86%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20apply%20formula%20in%20all%20sheet%2C%20select%20the%20sheet%20which%20you%20wish%20to%20Apply%20the%20formula%20and%20write%20your%20formula..%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20try%20Excel%20Tables%20that%20will%20automatically%20expand%20the%20range%20of%20your%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250559%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20cell%20equal%20to%20the%20formula%20in%20another%20cell%20and%20not%20its%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250559%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20first%20thought%20you%20misread%20my%20question%2C%20but%20this%20does%20solve%20my%20problem.%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EHerman%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250588%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20cell%20equal%20to%20the%20formula%20in%20another%20cell%20and%20not%20its%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250588%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F593346%22%20target%3D%22_blank%22%3E%40Herman86%3C%2FA%3E%26nbsp%3BGlad%20to%20hear%20your%20que%3CFONT%20color%3D%22%23000000%22%3Ery%20is%20resolved%20don't%20forget%20mark%20as%26nbsp%3BOfficial%20Answer%20to%20close%20the%20post%3C%2FFONT%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I have the following issue:

I have a file with numerous sheets with the same data columns (different data).
The final column is a formula column using the actual sheet's data for the calculation. Currently I will write the formula in the first sheet and then manually copy the formulas into the other sheets (very time consuming). Is it possible to set the columns in the remaining sheets equal to the formula in the first sheet so that if I change the formula it changes in all the sheets and I will not need to copy it every time manually? 

Thank you in advance. 

3 Replies
Highlighted

Hi @Herman86 

 

to apply formula in all sheet, select the sheet which you wish to Apply the formula and write your formula.. 

You should try Excel Tables that will automatically expand the range of your data.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Highlighted

Hi @Faraz Shaikh

I first thought you misread my question, but this does solve my problem.

Thank you!

Regards

Herman

Highlighted

@Herman86 Glad to hear your query is resolved don't forget mark as Official Answer to close the post 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.