Display different lists based on conditions in a dropdown menu

[kterkuile]

Could anyone point me in the right direction, please? I have a list with teamnames for my local poolcompetition. And, thanks for asking, mainly straight and 8-ball . Now, I use this list as input for a validation drop down list. Now comes the tricky part: for every team i have a list of teammembers. What i want is when i choose a certain team, i want the list of five, six or seven teammembers connected to that specific teamname automatically displayed in a column. So, when i change the teamname in my dropdownlist, i will see a different set of players on the spot where the former list used to be. How hard can that be, right: however, i can't seem to crack it.

I know and love dependent validation lists, however, and although what i want is much the same, it isn't exactly. I want the whole list and not a dropdown menu i can choose the right teammembers from.

Take care,

Karel

 

[kterkuile]

I've been thinking about it for a few days now. What i want is basically to display the whole named range of the same name that I choose from the drop down box.

Probably can't be done, judging by the flood of reactions . Oh well, you can't automate everything, can you.

Take care,

Karel