Forum Discussion
How can I create multiple dependent drop down lists
I want to create multiple dependent drop-down lists from the file below. When I select a country in column B I want only entries from column D for that country to appear in the next drop-down list, a...
This might add something new to the mix. It uses any current selection to filter other validation columns, so it can only be applied to a single combined selection. On the other hand, it prevents the user from selecting a new country without first deleting the region. An interesting characteristic of the validation occurs if 'Touba' is selected as a sub-region. Returning to the country, shows both 'Cote d'Ivoire' and 'Senegal' to be valid. 'Northern' similarly has multiple occurrences.
