Same Cell Name on Multiple Worksheets

[Guest]

I am trying to create the same cell name on multiple worksheets within a
workbook and having difficulties. I know this can be done by creating the
cell names on a single worksheet and then copying that worksheet but this is
a long way around if you just want to add one duplicate name. If I have an
existing cell name on Sheet1, how can I duplicate that cell name on Sheet2?
I'm using the Indirect function to get data from multiple worksheets that
have the same names. Thx.

 

[Guest]

Create the named range with the sheet name in front of the name something
like this...

Sheet1!MyCell
and
Sheet2!MyCell

 

[Guest]

Sorry Jim, either I'm not understanding or that didn't work quite right.
What you've listed would be how to reference the cell name on a specific
sheet but what I'm looking for is how to create the same cell name on
multiple sheets. For instance I would like to have a separate cell name
"COUNTER" on both Sheet1 and Sheet2. How would I create this?

 

[Dave Peterson]

When you're creating the name (insert|Name|define), make sure you include the
sheet name in the "names in workbook" box.

Something like Jim wrote:
Sheet1!Counter
or
'Sheet 9 9 9'!Counter

And you'll be making local/sheet level names.

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp