Home |
Search |
Today's Posts |
#1
|
|||
|
|||
validation drop down from closed workbook
I would like to have a drop down menu in a workbook that allows only values form another workbook that may or may not be closed at the time. Is this possible and if so I'd be grateful for any hints, tips and pointers in the right direction. Thanks as always -- karambos ------------------------------------------------------------------------ karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262 View this thread: http://www.excelforum.com/showthread...hreadid=398969 |
#2
|
|||
|
|||
This might work.
I created a new worksheet with formulas that refered back to the sometimes closed workbook: in A1:A10 ='C:\my documents\excel\[book1.xls]Sheet1'!A1 thru ='C:\my documents\excel\[book1.xls]Sheet1'!A10 Then I named that range (Insert|name|define). I called it myList. And then I hid that worksheet. Then I use data|validation for the cell I wanted and used: Allow: List source: =myList It seemed to work ok. karambos wrote: I would like to have a drop down menu in a workbook that allows only values form another workbook that may or may not be closed at the time. Is this possible and if so I'd be grateful for any hints, tips and pointers in the right direction. Thanks as always -- karambos ------------------------------------------------------------------------ karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262 View this thread: http://www.excelforum.com/showthread...hreadid=398969 -- Dave Peterson |
#3
|
|||
|
|||
You could use DataGet External Data New Database Query to pull the
values into your workbook, and base the data validation list on the query results. karambos wrote: I would like to have a drop down menu in a workbook that allows only values form another workbook that may or may not be closed at the time. Is this possible and if so I'd be grateful for any hints, tips and pointers in the right direction. Thanks as always -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force content in closed workbook | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |