software

Question:
I have created my drop-down list (under Datagt;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 quot;Group A, Group B, Group Cquot; in a
drop-down list, and you choose quot;Group Aquot;, then I was column *-B1-* to
populate a list of drop-down names for _only_ people in quot;Group Aquot;.

Any inputs/ideas would be greatly appreciated!Regards,

Giancarlo--
gtanti
------------------------------------------------------------------------
gtanti's Profile: www.excelforum.com/member.php...oamp;userid=34232
View this thread: www.excelforum.com/showthread...hreadid=539868Grancarlo, see if this will work for you,

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 amp; 2003

quot;gtantiquot; gt; wrote in
message ...
gt;
gt; Question:
gt; I have created my drop-down list (under Datagt;Validation). What I would
gt; like to do is to populate a following field after making a selection
gt; from my drop-down list.
gt;
gt; Example: If column *A1* contains quot;Group A, Group B, Group Cquot; in a
gt; drop-down list, and you choose quot;Group Aquot;, then I was column *-B1-* to
gt; populate a list of drop-down names for _only_ people in quot;Group Aquot;.
gt;
gt; Any inputs/ideas would be greatly appreciated!
gt;
gt;
gt; Regards,
gt;
gt; Giancarlo
gt;
gt;
gt; --
gt; gtanti
gt; ------------------------------------------------------------------------
gt; gtanti's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34232
gt; View this thread: www.excelforum.com/showthread...hreadid=539868
gt;