Same cell name in multiple worksheets

D

drew

I would like to name cells in multiple worksheets with the
same name. Is there an easy way to do this?

The only way I found to do this was to name the cells in a
worksheet that is in a seperate workbook. Then move the
worksheet to the desired workbook. It lets you add a
sheet that has names which are already assigned to other
cells in different sheets. However, this is a pain to do
each time and there has got to be an easier way.

Any ideas?
Thanks for you help.
 
F

Frank Kabel

Hi
if you want to name for example cell E8 individually try the following:
- goto 'Insert - Name - Define'
- choose a name
- enter the following reference:
=!$E$8

Note the exclamation mark at the beginning
 
D

drew

I want to name cell E8 on Sheet1 "Tax".
I also want to name cell E8 on Sheet2 "Tax".

I know how to name the first one. However, when I try to
name the second one, it changes the first.
 
F

Frank Kabel

Hi
- just open your workbook goto 'Insert - Name - Define#
- enter 'Tax' as name
- now enter
=!$E$8

this works for me
 
D

drew

Sorry, this just isn't working. It works for one
occurence if you add the sheet name after the =

When you try to name another cell in a different worksheet
within the same workbook, it changes the reference from
the first sheet to the new sheet.
 
C

Charles Williams

Hi Frank,

It really is not a good idea to recommend this type of name. There are
serious Excel bugs that may give incorrect calculation results.

if you want to recommend a solution then recommend =Indirect("$E$8")

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
R

RagDyer

Select the cell that you wish to name.
Click in the name box and type in the name of the sheet, followed by an
exclamation point, followed by the name that you wish to use.
For example:
Sheet1!tax
Do the same for any and all sheets concerned:
Sheet2!tax
Sheet3!tax
Sheet4!tax

This can also be accomplished a little easier, if you *haven't yet* created
the other sheets.

If you named A10 as TAX on Sheet1, using the above method, you could then
*copy* Sheet1, rename it to whatever, and TAX would be retained as a sheet
specific name on this new sheet.

Definately advise *against* using the exclamation in the "RefersToBox".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Sorry, this just isn't working. It works for one
occurence if you add the sheet name after the =

When you try to name another cell in a different worksheet
within the same workbook, it changes the reference from
the first sheet to the new sheet.
 
D

drew

That's it!

Typing the sheet name & "!" & then the cell name in the
name box lets me use the same name on multiple sheets.
That is a simple effective way to do it.

Thanks for your help.
 
Top