Creating conditional lists using VBA

[Grilleman]

Hello,

I have a worksheet that contains high level "product groups". Each of these contain like "product types". Within each "product type" I will sometimes have specific configurations.

What I want to do is:

a) Select a high level "product group" from the "Layout worksheet".
b) Next, I want to view a drop down list displaying only the product types that belong to that group
c) Finally, I want to view a drop down list displaying only those speciifc configurations that belong to the selected "product type".

I have attached a workbook that contains two sheets. The "Layout" sheet is where input selections are made. The "Group" sheet contains the actual data.

Any help with this will be greatly appreciated.

Thank you,

Grilleman

[Bob Phillips]

Try this

[Grilleman]

Awesome! Thank you very much!!