View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Excel Ranger Excel Ranger is offline
external usenet poster
 
Posts: 3
Default 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.