Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cascade Drop-Down Lists?
Hi all, not sure if this is possible, but can you create a cascading set of
drop down lists based on a single source of data? For instance, the data contains sales person information for a global sales team. Column A contains a pull down list of countries, B contains cities, C contains sales person name. The column A selection determines what is displayed in the column B pulldown, the B selection determines what is displayed in the column C pulldown. So if I select "USA" in A, B shows only "New York, Los Angeles, Chicago, Dallas, Atlanta...". Then selecting "Atlanta" in B causes only "Bill, Jack, Michelle, Ryan" in column C. I guess I could pivot this to filter the data, but I am looking to select certain sales persons for other purposes, not to view specific data about them. Thanks Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cascade Drop-Down Lists?
I believe the solution you're looking for can be found he
http://www.contextures.com/xlDataVal02.html "tommcbrny" wrote: Hi all, not sure if this is possible, but can you create a cascading set of drop down lists based on a single source of data? For instance, the data contains sales person information for a global sales team. Column A contains a pull down list of countries, B contains cities, C contains sales person name. The column A selection determines what is displayed in the column B pulldown, the B selection determines what is displayed in the column C pulldown. So if I select "USA" in A, B shows only "New York, Los Angeles, Chicago, Dallas, Atlanta...". Then selecting "Atlanta" in B causes only "Bill, Jack, Michelle, Ryan" in column C. I guess I could pivot this to filter the data, but I am looking to select certain sales persons for other purposes, not to view specific data about them. Thanks Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Cascade selection of Drop down menus | Excel Worksheet Functions |