There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html


Shannon wrote:
How do I validate data using different lists based on the data in another cell?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html