| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation from multiple lists
i have data validation for a cell set to allow data from a list using a named
range. can i make the name of the range in the data validation source field dependent on the value in another cell? ie: if i have 3 named ranges in rows 1:3 in columns a, b & c respectively and want the drop down in E1 to display only 1 of the 3 lists depending on the value in cell D2 how do i set up the data validation field? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Multiple Dependent Lists | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Multiple Validation Lists | Excel Worksheet Functions | |||
| Printing Multiple Data Validation Lists | Excel Worksheet Functions | |||
| Excel data validation multiple lists | Excel Programming | |||
Threaded Mode
