Hi,
I have an excel spreadsheet with 2 sheets. One has a drop down for State, then County, then City, then other information that is not important here.
Sheet two has Data. The data has State in Column A, County in Column B and City in Column C.
My drop down starts with selecting the State in Cell B3. C3 has the County. I want the drop down for County to only show the Counties that are listed in my data set for the state that is selected.
Then I want the Cities drop down to only pull cities for cities within that county based on my data in sheet 2.
Is there a way to do that? The counties and cities show up multiple times, so I only want the unique data to show in the drop down box.
Your help is much appreciated!
Thank you!
Bookmarks