Drop Down lists

G

Guest

Hello,

Question for excel masters! Is there a way to link 2 or more drop down
list. Adn then also omit informatin that does not relate to the first drop
down selection.

For example: First drop down list = Select NBA Team

New York Knicks
Sacramento Kings
Chicago Bulls
Detroit Pistons


I need that if you select an NBA Team then there will be another drop down
box to select say...Arena.

For example: user selects New York Knicks

Now you have another drop down box to select which arena

Select Arena:
Madison Square Garden
Apollo Theatre
St. John's University Gym
Other

So if you select NY Knicks, then the other arenas will not show up on the
second drop down list.

Also, can I make it that you must select a Team first before you can select
an Arena?

Any help would be awesome Masters!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lists 2007 10
Excel Excel: How do I put a formula in a drop down list 11
Link Drop Down with Pivot Table 2
drop down list 3
Drop down options 1
Starting drop down lists at the top 1
Excel 2007 drop down lists 6
Excel 2003: I need the Drop-Down List symbol to show all the time 1

Top