| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down lists
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down lists
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down lists
Check this out, good site to bookmark
http://www.contextures.com/xlDataVal02.html -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down lists
Thank's, you're great!
-- Thank You! "Gary''s Student" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down lists
Thanks, John!
-- Thank You! "John Bundy" wrote: Check this out, good site to bookmark http://www.contextures.com/xlDataVal02.html -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down lists | Excel Worksheet Functions | |||
| Drop down lists | New Users to Excel | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| drop down lists | Excel Worksheet Functions | |||
| Drop down lists | Excel Discussion (Misc queries) | |||
Linear Mode
