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...
Debra explains this quite well:
https://www.contextures.com/exceldependentdropdownsetup.html
https://www.contextures.com/exceldependentdropdownsetup.html
JKPieterse I do not seem to find a link to an example with a data set that is similar to the one I have. how to create a unique country drop-down list, then when you select the country only the provinces of that country show, and when you select a province only the district in that country shows.
- Which version of Excel do you have exactly?
- I have Office 365. And thanks for following up on his.