See Debra Dalgleish's site for using another workbook as the source for a DV
list.

NOTE..........the source WB has to be open.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 06:55:01 -0700, weswhite7
wrote:

I'm trying to create a list in a workbook from a range of cells in a
different worksheet in a different workbook. I have worked through Excels
guide on how to create a drop-down list from a range of cells, however, when
I follow the steps exactly and then go through the validation, it tells me
"You may not use references to other worksheets or workbooks for Data
Validation criteria." Yet, these are instructions that are provided by
Microsoft Excel on how to create a drop-down list from an external workbook.

Any help here? If you search in the box for create list and then select the
"Create a drop-down list from a range of cells" instruction that is what I
have been using.

Any help would be appreciated. Thanks.