VBA FOR TWO INTERACTING DATA VLAIDATION DROPDOWNS

[PW1202]

Hello from sunny Australia. I have two Data Validation dropdowns where the 2nd dropdown depends on the contents of the first dropdown. To explain it better, I have attached a jpg explaining the interaction. Any help greatly appreciated. Peter.

[Bob Phillips]

Do you have the dependent data as separate lists? Post your workbook, it should be a doddle then.