| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Lists
Is it possible to use Data Validation where the list of values is on one
worksheet but the dropdown list is on another worksheet? Excel won't let me do that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation Lists
If you select the list, then do insertnamedefine, give it a name and refer
to the name like =MyList in the list source box will work -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Mike" wrote in message ... Is it possible to use Data Validation where the list of values is on one worksheet but the dropdown list is on another worksheet? Excel won't let me do that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation and named lists | Excel Worksheet Functions | |||
| Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
| 6 Data Validation lists depending on 1 cell value | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| how to add two data validation lists to a single cell? | Excel Worksheet Functions | |||
Hybrid Mode
