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

Drop down lists in seperate columns 5
Help with drop down selection and populating related data... 9
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Validation of cell based on Drop down list 1
Sumif does not work 2
Linking drop down lists to another list 2
Drop-down Delete Multiples 1
dependent, multiple variable, drop down list 2

Top