View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Worksheet name after copying

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