Hello,

I have scoured the net for the following and have not been able to find a solution. I have found variations but not something specific for the use needed here.

I have attached a file with sample data which has the following format.

Column 1 = vehicle model (in this example golf, jetta, but there will be over 100 choices)

Column 2 = vehicle package option for specified vehicle model (automatic transmission, manual transmission, automatic transmission with air conditioning, etc...)

Column 3 = vehicle colour available for vehicle package option

Please note that Column 2 values for 'golf' are different than values available for 'jetta' (in the sample data I have blocked out common values with the same colour for quick and easy identification)

Also please note that Column 3 values of colour options vary for each 'vehicle package option'.

The behaviour that would be ideal is to have 3 drop down menus. The first drop down menu will allow selection from column 1 and will show each model only one time and repeated values will not be shown. The second drop down menu will only show the options available based on the selection in the first drop down menu. Likewise, the third drop down menu will show the colour options available based on the selection in the second drop down menu.

Since my data will involve hundreds of unique values in column 1 with plenty more added over time, it seems that the format of the data and the way it is laid out in the attached sample is the easiest way to organize it. It is perhaps also the easiest way to include new data without a lot of reprogramming but I am open to suggestions.

Thank you for your help and suggestions.

TV

Sample Data - Dependent Drop Down Cells Question.xlsx