How can I reuse the same Name on more than one worksheet?
 

I have a multiple worksheets in my workbook. I want to name a cell on each
workbook by the same name "Litres" - note: I do NOT want a 3D reference to
all at once, but individual references.
On the same spreadsheet somehow I've managed this before - I have a name
"Business" that is context-specific on whichever sheet I happen to be on, but
I can't remember how I created it! Looking at at in the 'Names' dialog box,
it appears in the list as:
Business June
....where 'June' is the current sheet name. Can anyone help me with creating
a reference like this?

Trevor,
To use the same name range on each sheet

Insert | Name | Define

and type in the name you want to give the range prefixed by the sheet name
and an exclamation point into the *top* text box; e.g.:

Sheet1!MyRange


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Trevor Heywood" <Trevor wrote in message
...
I have a multiple worksheets in my workbook. I want to name a cell on each
workbook by the same name "Litres" - note: I do NOT want a 3D reference to
all at once, but individual references.
On the same spreadsheet somehow I've managed this before - I have a name
"Business" that is context-specific on whichever sheet I happen to be on,
but
I can't remember how I created it! Looking at at in the 'Names' dialog
box,
it appears in the list as:
Business June
...where 'June' is the current sheet name. Can anyone help me with
creating
a reference like this?

Hi

When you name your cells, you need to prefix the name with the sheet ref eg
sheet1!top, sheet2!top etc
Hope this helps.

--
Andy.


"Trevor Heywood" <Trevor wrote in message
...
I have a multiple worksheets in my workbook. I want to name a cell on each
workbook by the same name "Litres" - note: I do NOT want a 3D reference to
all at once, but individual references.
On the same spreadsheet somehow I've managed this before - I have a name
"Business" that is context-specific on whichever sheet I happen to be on,
but
I can't remember how I created it! Looking at at in the 'Names' dialog
box,
it appears in the list as:
Business June
...where 'June' is the current sheet name. Can anyone help me with
creating
a reference like this?