D
david
In Excel97 I'm trying to use the same cell name in
multiple worksheets. Within a workbook I create a new
worksheet by copying an "original" sheet and Excel starts
a dialogue that asks me if I want the names on the new
sheet to refer to the cells on the original sheet or
whether I'd like to rename the cells. There's no choice
for having the same name on multiple sheets. I know this
is possible because I have worksheets where the same name
on multiple sheets refer to different cells. Problem is I
can't recall (premature brain deterioration?) how I got
it. Perhaps with templates?
Thanks for responding!
multiple worksheets. Within a workbook I create a new
worksheet by copying an "original" sheet and Excel starts
a dialogue that asks me if I want the names on the new
sheet to refer to the cells on the original sheet or
whether I'd like to rename the cells. There's no choice
for having the same name on multiple sheets. I know this
is possible because I have worksheets where the same name
on multiple sheets refer to different cells. Problem is I
can't recall (premature brain deterioration?) how I got
it. Perhaps with templates?
Thanks for responding!