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

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