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
 
Ad

Advertisements


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

Top