Drop down list

[Jeff H]

How do I create a drop down list from a range of cells in another workbook.
I've followed the HELP directions line by line and they do not get me there.

 

[Peo Sjoblom]

If you mean data>validation then you need to name the range in the other
workbook and it needs to be open

http://www.contextures.com/xlDataVal05.html



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com