Data Validation - List from another worksheet

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

Hi

I've created a range name that is located on a a second
worksheet.

How do I get the source dialog to accept the range name?
I've tried "=rangename", "=Sheet2!A1:A231"....



Hi

With validation list, only cell references to same
worksheet are allowed.
To refer to list on another worksheet in same workbook,
you have to define
the list as named range (Insert.Name.Define...)
To refer to list in another workbook, the safest way will
be mirroring it
into some sheet (links or ODBC query), define the
mirrored list as named
range, and refer to named range as list source.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


message
news:[email protected]...
 
It sounds like you did it correctly (=rangename is correct). You named that
range on sheet2 "rangename" (w/o the quotes?)

And you selected List in the Allow dropdown.

Debra Dalgleish has pictures explaining this at:
http://www.contextures.com/xlDataVal01.html#Dropdown

(but I'd just try it once more--maybe you didn't successfully create the range
name. When you hit F5 (edit|goto) and type in rangename and do you go to the
range you wanted?
 
Back
Top