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