see:

http://www.contextures.com/xlDataVal13.html
--
Gary''s Student
gsnu200707


"maijiuli" wrote:

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!


--
Thank You!