| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying different validation lists
In column "A" I have established a data validation list of "Phases". In
column "B" I would like to display different validation lists ("Activities") depending on the choice made in column "A". For example, if a user selects "Phase 2" in column "A", then the validation list in column "B" would display "Activity E", "Activity L", and "Activity M". But if a user selects "Phase 5" in column "A", then the validation list in column "B" would display "Activity Q", "Activity T", and "Activity Z". Can this be done without macros? Any help would be greatly appreciated. Thanks, Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In-Cell Dropdown for validation not displaying | Excel Discussion (Misc queries) | |||
| Data Validation - Using 2 Lists | Excel Discussion (Misc queries) | |||
| Data Validation lists display bottom vs top | Excel Discussion (Misc queries) | |||
| 2 different INDIRECT data validation lists from one | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
Threaded Mode
