Using Forms in my spreadsheet
 

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.

Using Forms in my spreadsheet
 

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.

Filters in Pivot Tables
 

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.

Filters in Pivot Tables
 

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