You can create dependent data validation lists. There are instructions
here:

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


fdebelo wrote:

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