Forum Discussion
Dependent Drop Down Lists
Hey - please can someone advice me of the best way to create a database in the following way
I would like to use three drop down lists, each dependent on the one before it.
The first drop down list should be named 'Positions'. The user will be required to select from a number of positions, i.e. 'position 1', 'position 2', 'position 3', etc.
Based on the role selected in the first drop down list, I would like to have the second drop down list then automatically display all the people who work in that role, i.e. 'person 1', 'person 2', 'person 3', etc.
Based on the person selected in the second drop down list, what I would like to have is a third drop down list with categories such as 'email', 'phone number' and 'skills', which when selected displays the selected persons information, i.e. their email address, phone number, skills, etc.
I hope this all makes sense and will be very grateful for any help!
9 Replies
Hi,
The template I created by adding dependent drop-down lists on the userform may be useful for you.
There are 3 dependent drop-down lists and a textbox on the userform. In the first drop-down list, suppliers are listed, categories according to the selected supplier are listed, products according to the selected category are listed. Finally, the price of the selected product is shown in the textbox.Source and sample file at : https://eksi30.com/create-dynamic-dependent-drop-down-lists-on-userform/
Thanks
I recommend using Excel Tables that has dynamic range feature. Excel Table is available in Excel 2007, 2010, 2013, 2016, 365
Please see attached workbook.
Edit: attached workbook.
Thanks so much for this - the Excel tables with dynamic range feature is just what I'm looking for.
Do you know if it's possible to hide results until selections have been made?
E.g.
1) In the first drop down list Select 'Role 1'
2) In the second drop down list select 'Person 1'
3) In the third drop down list select 'Email'
4) Only result displayed is the email address of Person 1
Thanks again
Please see attached.
with your additional criteria you need three dropdowns and one cell to return the details based on the three selections of dropdowns, if the dropdown data is selected incorrectly then it will show a text in that yellow cell.
- There is an excellent toturial on dependent Validation lists here: http://www.contextures.com/xlDataVal02.html
