Using Forms in my spreadsheet

J

Jon

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.
 
E

Excel Ranger

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.
 
R

RM

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!!!
 

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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Check Spreadsheet entries against a list 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Help with drop down selection and populating related data... 9
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Drop Down that returns value in same table 5
Clearing Fields in a Word Form 5
Select Drop-Down list entry by typing 0

Top