Hi all
I have a series of work sheets ( sheet1 thru sheet8) all are linked to
another sheet (sheet9) that displays the data that I need from each (sheet1
thru sheet8). I want to be able to rename any worksheet such as rename to
(sheet1a thru sheet8a)
and then create another blank copy of(sheet1 thru sheet8).
When I do this renaming, the formula automatically refers to the renamed
version of the original sheet "the formula that refered to sheet1 now refers
to sheet1a"
How can I protect my formula so it will always refer to sheet1 or shhet2 etc.
Please help. All else is working as I planned but this is messing it all up
--

--
cruchnin numbers

If you rename sheet1 to sheet1A and try to keep the formulas still pointing at
Sheet1, all your formulas will break. They'll refer to a worksheet that doesn't
exist.

Maybe just copying sheet1 to sheet1a would be better??????
(Edit|Move or Copy Sheet and check that "Create a copy" box)

belvy123 wrote:

Hi all
I have a series of work sheets ( sheet1 thru sheet8) all are linked to
another sheet (sheet9) that displays the data that I need from each (sheet1
thru sheet8). I want to be able to rename any worksheet such as rename to
(sheet1a thru sheet8a)
and then create another blank copy of(sheet1 thru sheet8).
When I do this renaming, the formula automatically refers to the renamed
version of the original sheet "the formula that refered to sheet1 now refers
to sheet1a"
How can I protect my formula so it will always refer to sheet1 or shhet2 etc.
Please help. All else is working as I planned but this is messing it all up
--

--
cruchnin numbers

--

Dave Peterson