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