There are instructions here for creating dependent data validation lists:

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


Ray wrote:
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc


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