moving worksheets and formulas

[butzalan1958]

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

[#2]

@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.