Populating Drop-Down lists

Question:
I have created my drop-down list (under Data>Validation). 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

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" <[email protected]> wrote in
message news:[email protected]...
>
> Question:
> I have created my drop-down list (under Data>Validation). 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
>