moving worksheets and formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2121906%22%20slang%3D%22en-US%22%3Emoving%20worksheets%20and%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121906%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20set%20up%20formulas%20in%20worksheet%201%20from%20data%20in%20worksheet%202.%20I%20am%20now%20moving%20worksheet%202%20to%20worksheet%203.%20Will%20the%20formula%20in%20worksheet%201%20automatically%20change%20to%20worksheet%203%20info%3F%20If%20not%20is%20there%20a%20way%20I%20can%20change%20it%20without%20manually%20typing%20new%20formulas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2121906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2122175%22%20slang%3D%22en-US%22%3ERe%3A%20moving%20worksheets%20and%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2122175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F963774%22%20target%3D%22_blank%22%3E%40butzalan1958%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20mean%20under%20%22%3CSPAN%3Emoving%20worksheet%202%20to%20worksheet%203%22%20%3F%26nbsp%3B%20If%20change%20sheet%20position%20and%2For%20rename%20it%20-%20formula%20will%20be%20adjusted%20automatically.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIn%20any%20case%2C%20before%20starting%20global%20changes%20in%20work%20file%20I'd%20recommend%20to%20play%20with%20small%20test%20file%20if%20you%20are%20not%20sure%20in%20results.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I have set up formulas in worksheet 1 from data in worksheet 2. I am now moving worksheet 2 to worksheet 3. Will the formula in worksheet 1 automatically change to worksheet 3 info? If not is there a way I can change it without manually typing new formulas?

 

Thanks,

 

Alan

1 Reply

@butzalan1958 

What do you mean under "moving worksheet 2 to worksheet 3" ?  If change sheet position and/or rename it - formula will be adjusted automatically.

 

In any case, before starting global changes in work file I'd recommend to play with small test file if you are not sure in results.