Hello,

I'm hoping someone may be able to help with my question.

Here's where I'm at. On one tab i have a drop down list that can select a house model. underneath i would like a complete list of options to populate for that model. The complete library is stored on another tab and i would like only the corresponding options to show when the model is selected.

House model DROP DOWN LIST (X)

Options:
x1 _______
x2 ______
x3 _____


Library
x1 ______
a1 _____
b1 _____
x2 _____
b3 _____
A2 ______
x3 ______

Something like the above, where if x is selected only those items appear from the library (without blanks)

help me obiwan, you our only hope

chances are this has probably been answered somewhere, so please direct me there if thats the case and I thank you in advance.