naming

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

Hi guys remember me...
I'm not sure if I need to repost... I will

So maybe i just don't get it.
I have a book (checks), with sheets with peoples names
sam, frank etc. In this book I named a range salary =!
$d$22
In a diff book I enter =[checks.xls]sam!d22 and I get the
value. If I replace the d22 with salary, the formula
changes to =checks.xls!salary and returns #ref. It won't
let me reference a specific sheet.

What am i missing if this is suppose to work?

peter
 
Hi Peter
I've tried to recreate the error your refering to, and
I've had no problems with it.
The only thing I can think of is that each named range in
a workbook must be unique, you cannot have a named range
called "salary" for each sheet.
This may be no use at all, but I hope it helps.

Paul
 
Peter,

When you name the range, salary, it needs to include the
sheet reference, i.e. Sam!d22, without the sheet reference
within the named range, the reference doesn't know where
to look.

Steve
 
Paul,

Named ranges do nor have to be unique, there are workbook names and
worksheet names,

As an example, goto sheet1 and in the Insert>Names, add names of

Sheet1!Paul - refers to =Sheet1!$A$1

goto sheet2 and Insert>Names, addames of

Sheet2!Paul - refers to =Sheet2!$A$1

and then put different values into A1 in these sheets. In another cell,
input

Then in a cell input
=Sheet1Paul

and in an other

=Sheet2!Paul,

you should get the idea.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top