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