I want to create a way for a user to select a state from a drop down then
have another drop down populate all of the counties for that state. By
knowing the State and County I can return specific information from by data.
By using forms I was able to create the state drop down but I can't figure
how to tie this back to the counties without listing all 3,145 counties.

You would have to create lists to support this. You are talking about
"dependent drop-down lists". The list with the 50 states would be easy
enough. You could copy and paste from a source online. But then you would
need another 50 lists for the applicable counties. Again, I would copy and
paste from somebody else's hard work in the virtual world.

"Jon" wrote:

I want to create a way for a user to select a state from a drop down then
have another drop down populate all of the counties for that state. By
knowing the State and County I can return specific information from by data.
By using forms I was able to create the state drop down but I can't figure
how to tie this back to the counties without listing all 3,145 counties.

Can this be done on a pivot table?

We have customers with multiple products, but each customer only buy a few
products. When filtering the pivot table, I want to be able to select a
customer, and only be able to select the products that they sell and not all
products?

Do I make myself clear?

thanks in advance!!!


"Excel Ranger" wrote:

You would have to create lists to support this. You are talking about
"dependent drop-down lists". The list with the 50 states would be easy
enough. You could copy and paste from a source online. But then you would
need another 50 lists for the applicable counties. Again, I would copy and
paste from somebody else's hard work in the virtual world.

"Jon" wrote:

I want to create a way for a user to select a state from a drop down then
have another drop down populate all of the counties for that state. By
knowing the State and County I can return specific information from by data.
By using forms I was able to create the state drop down but I can't figure
how to tie this back to the counties without listing all 3,145 counties.

Excel 2007 Table gives you dependent
drop-down lists and sums.
Pivot Table still shows all products.
For a comparison see:
http://www.savefile.com/files/1412986