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.

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

Sheet1!MyCell
and
Sheet2!MyCell

--
HTH...

Jim Thomlinson


"Chris" wrote:

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.

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?

"Jim Thomlinson" wrote:

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

Sheet1!MyCell
and
Sheet2!MyCell

--
HTH...

Jim Thomlinson


"Chris" wrote:

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.

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


Chris wrote:

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?

"Jim Thomlinson" wrote:

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

Sheet1!MyCell
and
Sheet2!MyCell

--
HTH...

Jim Thomlinson


"Chris" wrote:

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.

--

Dave Peterson