Here is my fomula =TL2!$E$5 - just a basic cell copy refernce from another
worksheet; but when I copy the original worksheet it displays a new sheet as
TL (2).


"Sean Timmons" wrote:

Depends on the formula. Usually, you can use INDIRECT()

So, INDIRECT("TL!A2")

Will retain TL as the sheet name even after you make a copy.

"Anitykk" wrote:

I understand that but when a copy the worksheet and it changes the name to TL
(2) my rollup sheet formulas will not read the ( ) - how can I get the name
to change automatically to say TL2

"Peo Sjoblom" wrote:

You can't have 2 sheet with the same name in the same workbook, so you would
need to change the name, you can
do that by right clicking the tab and select rename. Look also at templates
in help

--


Regards,


Peo Sjoblom


"Anitykk" wrote in message
...
I am working with a worksheet that I copy (keeping same blank form) but the
name changes from TL to TL (2) which I cannot use in my rollup as the
formula
won't read. Could anyone help me figure a way to keep the new worksheet
name
from adding the ( ) so that my formulas will work