| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
