There are instructions here for creating dependent data validation lists:

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

Alex3020 wrote:
Say I have the cell A1 - it has a drop down menu and Cell A2 also has a drop
down menu.
I want the drop down menu of A2 to change based on the value in A1


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html