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