Problem with Defined Names

J

Joe Blow

Hi,

I have a spreadsheet that I copy a worksheet from the previous week
(ie wk39) for use as the current week (ie wk40).

Problem is when I have a name defined in wk39 it now travels to wk40.
When I look in Insert->Name->Define, all of the previous defines are
now defined as =wk40!XX:XX

Is there a way to prevent the defines from traveling to a copied
worksheet?

Thanks,
Joe
 
J

Joe Blow

Hi,

I have a spreadsheet that I copy a worksheet from the previous week
(ie wk39) for use as the current week (ie wk40).

Problem is when I have a name defined in wk39 it now travels to wk40.
When I look in Insert->Name->Define, all of the previous defines are
now defined as =wk40!XX:XX

Is there a way to prevent the defines from traveling to a copied
worksheet?

Thanks,
Joe
Click to expand...

Anybody able to help?

Does the problem need clarification?

Joe
 
Top