Dear forum members,
I hope my question can be solved easily....
I have 1 column with brands and the 2nd column with their models.
So For Example it should look like :
Brand Model
A Model A1
A Model A2
A Model A3
A Model A4
B Model B1
B Model B2
B Model B3
C Model C1
etc.
I want use 2 validation cells with the first to select the brand but then the 2nd cell should give me a pull down list with only the models of the selected brand ?
Note that there are over 84 brands and a total of 470 models divided over all brands.
Hope someone can help me find the easiest solution.
Most Ideal would be that i could type in the first letters of the brand to select quicker in stead of scrolling down 84 times.
Kind regards,
Bert
Bookmarks