Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |