Grancarlo, see if this will work for you,

http://www.contextures.com/xlDataVal02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gtanti" wrote in
message ...

Question:
I have created my drop-down list (under DataValidation). What I would
like to do is to populate a following field after making a selection
from my drop-down list.

Example: If column *A1* contains "Group A, Group B, Group C" in a
drop-down list, and you choose "Group A", then I was column *-B1-* to
populate a list of drop-down names for _only_ people in "Group A".

Any inputs/ideas would be greatly appreciated!


Regards,

Giancarlo


--
gtanti
------------------------------------------------------------------------
gtanti's Profile:
http://www.excelforum.com/member.php...o&userid=34232
View this thread: http://www.excelforum.com/showthread...hreadid=539868