There are instructions here for creating dependent data validation lists:
http://www.contextures.com/xlDataVal02.html
Keyvan wrote:
Dear Sirs,
How may have a validation list depend on other cell?
for example if A1 is 1 then B1 can be: Mike, Jullie, peter; and if A1 is 2
then B1 can be: mary, frank, Jessica.
thank you for your help
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html