PDA

View Full Version : Creating conditional lists using VBA



Grilleman
02-28-2010, 05:43 PM
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
02-28-2010, 06:28 PM
Try this

Grilleman
03-01-2010, 06:01 AM
Awesome! Thank you very much!!