Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
71
Views
Topic starter
Good day
I have this excel file, I want to create a dropdown list with Districts, Sub-Districts and facilities, I need help so that when I click on a District all the Sub-Districts that fall under it will be listed then all the facilities that fall under that sub-district will show, the worksheet is the same for everything(Districts, Sub-Districts & facilities), just different data. Please help.
Posted : 11/04/2024 4:58 pm
Hello,
Check out the blog article Dynamic Dependent Data Validation to see one way to get what you want.
If you need hands on help, please uploade a sample file.
Br,
Anders
Posted : 13/04/2024 3:53 pm
