| View previous topic :: View next topic |
| Author |
Message |
Tom P
General User
Joined: 18 Oct 2010
Posts: 12
|
 Posted: Fri May 13, 2011 7:57 am Post subject: copy sheet and defined names |
 |
|
Apologies if this has been covered elsewhere, but I couldn't find anything.
I have a sheet and I have defined various cells with names, and use these names to define contents of other cells on the same sheet.
For example,
xyz is defined as cell $Sheet1.$B$5, and I have some other cell $B$6 with contents xyz*xyz-1.0
If I then copy the sheet, the new sheet is called $Sheet1_2, but $Sheet1_2.$B$6 still refers to the original definition of xyz on Sheet1, and not $Sheet2.$B$5.
Is there some way to to copy the sheet so that cells refer to the copy and not to the original sheet? Put another way - can names be defined to be local to the sheet and not global?
(Note - typo edited) |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
Tom P
General User
Joined: 18 Oct 2010
Posts: 12
|
| Posted: Fri May 13, 2011 1:37 pm Post subject: |
|
|
Great! That's what I need.
Is there a way to make this the default behaviour when you add a name definition? |
|
| Back to top |
|
|
|
