Defining same name for cells in different sheets

[Parisicaine]

Does anyone know the answer to this one?
I want to give the same range name to the same cell
reference in a series of worksheets.
I find I can do this by pre-defining all my range names on
a "master" worksheet and making several copies of the
sheet (try it, it works!)
But let's say I have done this, and entered all my data on
the sheets I have created, and suddenly realize I need
another range name. I haven't found any way to define a
new range name and apply it to the same range on several
sheets.
This is not the same as a 3-D reference, which I tried. (3-
d referencing groups together in one range name cells over
several worksheets.)
What's the trick? I haven't found the answer to this
anywhere?
Thanks in advance!
Parisicaine

 

[Bob Phillips]

Goto Insert>Name Define
In the Names in Workbook, enter
'Sheet1'!myRange
or whichever sheet is appropriate,
in the RefersTo box, ebte
='Sheet1'!$A$1
or the appropriate range.

replicate on each applicable sheet.

 

[Parisicaine]

Thanks for your quick answers.
I'll try them out.
Best regards,
Parisicaine