Feb 11 2021 08:12 AM
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
Feb 11 2021 10:37 AM
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.