How to create drop down list that determines another drop down list?

[Darren D.]

Hey all,

Here is an example of what I am trying to do. I have a list of ten
baseball teams with 20 players on each team. I want to create a drop
down box that will allow me to select one of the ten teams and then a
second drop down box below the first that will give me the list of the
20 players on the team I have selected in the first box. Then I want
to choose that player to enter his statistics. Is this possible? Any
help is much appreciated.

THANKS in advance,

Darren D.

 

[Guest]

Darren
You can use the selection from the first pulldown as the defined name for the second selection list

Then in the second pulldown use list, and enter =INDIRECT(cell reference of first pull down) as the source

Hope this gets you started

Good Luck
Mark Graesse
(e-mail address removed)


----- Darren D. wrote: ----

Hey all

Here is an example of what I am trying to do. I have a list of te
baseball teams with 20 players on each team. I want to create a dro
down box that will allow me to select one of the ten teams and then
second drop down box below the first that will give me the list of th
20 players on the team I have selected in the first box. Then I wan
to choose that player to enter his statistics. Is this possible? An
help is much appreciated

THANKS in advance

Darren D

 

[Debra Dalgleish]

If you need more help, there are some detailed instructions here:

http://www.contextures.com/xlDataVal02.html