Cascade Drop-Down Lists?

T

tommcbrny

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
 

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

Linking drop down lists to another list 4
Drop-down Delete Multiples 1
How can I shortlist cities based on the country selected in Excel 1
Related drop down lists 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down Lists 2
Drop down lists 1
How to create 2 dependent drop down lists from 1 original drop dow 5

Top