ChemistB,

I was expecting a bunch of VBA code, so it is pretty cool and amazing you made it work without it. I'm assuming this should work just as well with 2 workbooks where all source data will be in one workbook and the drop down list will be in another.

There are a couple of subtle quirks. When selections in the three drop down lists have been made moving left to right, backtracking and changing a value in the vehicle package option allows the colour choice to remain as it was set even if that colour choice is not available for that vehicle package option. Might there be a way to blank out a value in a list box when the value in the combo box to it's left is being altered?

Also, the drop down lists work in row 2 on sheet 2 where you placed them. If I copy and paste the row to another location the dynamic relationship no longer works.

Thanks so much for pulling this together. It was really neat to see it done without VBA. In my mind I'm trying to see how it might come together via VBA as well.

Cheers,

TV