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