Hi,
Column A of my sample worksheet has a dropdown for State, which is based on the list of states in Column E.
Column B of my sample worksheet NEEDS a dropdown for City, which is based on the list of States and Cities in Columns H and I.
I have added a graphic to show what I would like to see for Column B. The state chosen is Alabama so the dropdown for City needs to show the list of cities in Alabama.
Can anybody help with this?
I have seen similar solutions but not one in which the second dropdown needs to selectively filter the City list to match the state.
Thanks for looking!
Bookmarks