| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying different validation lists
You can create dependent data validation dropdowns, as described he
http://www.contextures.com/xlDataVal02.html Since your first list has multiple word items, note the instructions in the 'Using Two-Word Items' section. Bob wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying different validation lists
See http://www.contextures.com/xlDataVal02.html
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Bob" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying different validation lists
Bob
See Debra Dalgeish's site for "dependent DV dropdowns" http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Mon, 18 Dec 2006 11:54:07 -0800, Bob wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying different validation lists
Debra - Thanks!
Bob "Debra Dalgleish" wrote: You can create dependent data validation dropdowns, as described he http://www.contextures.com/xlDataVal02.html Since your first list has multiple word items, note the instructions in the 'Using Two-Word Items' section. Bob wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying different validation lists
Bob - Thanks!
Bob "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal02.html -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Bob" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying different validation lists
Gord - Thanks!
Bob "Gord Dibben" wrote: Bob See Debra Dalgeish's site for "dependent DV dropdowns" http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Mon, 18 Dec 2006 11:54:07 -0800, Bob wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
