I wanted to create a dynamic drop down/data validation that is dependent on the previous selection, I saw some samples online but those examples forces me to name the column headers using the values on the first column. It seems impossible for me to explain the functionality I need without images so I will attach the images first. This is just a sample table
This is my first Table:
Table1.JPG
I have Column Name and Contact #, as you can see it is possible that there are names with multiple entries(contact numbers)
Here's my second table where I want to put my drop downs
Table 2.JPG
I just want the drop down under customers reference to Names Column from the previous table but with unique distinct values
drop down for contact numbers for all contact numbers registered with the name I select from the previous drop down.
hope you gusy can help me I am new here and a noob in excel an I want to learn
Bookmarks