names, labels

[Theodore Bartley]

I have 12 worksheets, one for each month of the year. Each worksheet does
identical calculations, so I need the names to be worksheet defined rather
than workbook defined. And indeed they seem to be, yet they still cross
sheet boundaries. For example on the June sheet, Insert>Name>Define shows:
Loan =June!$D$8:$D$15 but the July, August, etc. sheets all see the June
definition of Loan. In other words, if on the August sheet I use
=sum(Loan), it calculates the result for the June sheet. I would have
thought that June! would have hidden these names from any other sheet. How
do I keep my name definitions to work only for their own sheet? Thanks,
Theo

 

[Guest]

When you define the name, you must include the sheet name as part of the name itself. So, instead of Loan as =June!$D$8:$D$15, define June!Loan as =June!$D$8:$D$15

 

[Dave Peterson]

When you define a name, you can use the sheet name in the "Names In Workbook"
box.

name: June!Loan
refers to: =june!$d$8:$d$15

Then when you do Insert|name|define, you'll see the sheetname in the box below
the Names in workbook box.

And if you want to save time converting these, download Jan Karel Pieterse's
(with Charles Williams and Matthew Henson) Name Manager.

You can find it at:
NameManager.Zip from http://www.bmsltd.ie/mvp

You'll be very happy.

 

[RagDyer]

And, if you create your range names to include the sheet name from the very
beginning (first worksheet), *every* sheet that you copy from this first
sheet will then have *all* the ranges copied as sheet specific range names.
--

HTH,

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

I have 12 worksheets, one for each month of the year. Each worksheet does
identical calculations, so I need the names to be worksheet defined rather
than workbook defined. And indeed they seem to be, yet they still cross
sheet boundaries. For example on the June sheet, Insert>Name>Define shows:
Loan =June!$D$8:$D$15 but the July, August, etc. sheets all see the June
definition of Loan. In other words, if on the August sheet I use
=sum(Loan), it calculates the result for the June sheet. I would have
thought that June! would have hidden these names from any other sheet. How
do I keep my name definitions to work only for their own sheet? Thanks,
Theo