Can a dropdown box reference to another workbook?

[Megtastic]

I am trying to create a dropdown list that will refernce to another workbook
where i will have a parts list, so that i can then use VLOOKUP to give me
details such as prices/part numbers. Is this possible to do?

 

[L. Howard Kittle]

Select the parts list on the other sheet and name it using the name box.

On the VLOOKUP sheet install your data valadation using List and in the
Source box enter =YourListName.

HTH
Regards,
Howard

 

[L. Howard Kittle]

Woops... My bad. I read another worksheet instead of workbook.

A named range will not work from another workbook as far as I tested it.

Sorry.

Regards,
Howard

 

[L. Howard Kittle]

From a Google search...read line six.

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.


--
Arvi Laanemets

HTH

Regards,

Howard

 

[Gord Dibben]

Yes.

The other workbook must be open.

See Debra Dalgleish's site for instructions.

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


Gord Dibben MS Excel MVP