ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/86927-drop-down-list.html)

Jeff H

Drop down list
 
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

Drop down list
 
If you mean datavalidation 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



"Jeff H" <Jeff wrote in message
...
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.





All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com