Data Validation - can you use another workbook?
 

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

Data Validation - can you use another workbook?
 

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

"Don" wrote:

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

Data Validation - can you use another workbook?
 

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

On Thu, 10 Jul 2008 05:16:00 -0700, Don wrote:

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

Data Validation - can you use another workbook?
 

--
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" wrote:

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

On Thu, 10 Jul 2008 05:16:00 -0700, Don wrote:

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

Data Validation - can you use another workbook?
 

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

On Sun, 3 Aug 2008 09:36:00 -0700, deek
wrote:

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" wrote:

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

On Thu, 10 Jul 2008 05:16:00 -0700, Don wrote:

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