Copying Tabs (worksheets) with formulas and renaming Tab

[mattbird]

Hi,

I'm not sure if what i am asking can be done or not, but here we go.

I have two worksheets in my workbook named 'List' and 'Stats' and they have formulas that work with each other. If I decide to change the name of my tabs all the formulas update which is great. However, when I copy the two worksheets and reman them to 'Risk' and 'Risk Stats' the formulas do not update and remain as 'List' and 'Stats'.

Is there a way of doing this, or do I have to individually amend all my formulas to 'Risk' and 'Risk Stats'? as this will take a long time!

your help is greatly appreciated.

 

[Tom Urtis]

First (maybe second), it would not take a long time to edit the formulas; you can Find and Replace for formulas only.

Second (maybe first), please explain how you are copying the two worksheets. The problem you are having might be stemming (based on your answer to this question) from new (to Excel) worksheet objects.

 

[mattbird]

It will only let me copy one sheet at a time due to the tables. Well that’s what it states when I try to copy both.

I am right clicking on the tab and selecting move/copy, then place where I want to copy it (end of list etc) and ticking the copy box