Data Validation - can you use another workbook?

[Don]

morning friends

Is there a way to use the Data/Validation List to use a named range in
another workbook? I want to maintain the list in one place yet have mult
workbooks utilize this so when I have to update the list of dropdowns , I can
do it in one place.

thanks

 

[Don]

my own suggestion, on the sheet in the workbook that has the named range for
the data validation, link to another sheet. simple and will work

 

[Gord Dibben]

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal05.html

Note: the workbook must be open to use the range in another workbook.


Gord Dibben MS Excel MVP

 

[deek]

--
deek
I am trying to use this tip and am running into problems. When I list into
the schedule = EmployeeList I get #NAME? not # VALUE! error. Do you have any
suggestions where I am going wrong?

 

[Gord Dibben]

Sounds like you are typing =employeelist into a cell.

The instructions at Debra's site are quite clear.

You need a named range in source workbook.............employeelist

In Refers to: =sheet!cellrange

You need a named range in DV workbook

In Refers to: =sourcebook.xls!employeelist

In DV book in DV source type =MyList


Gord