Need Macro Help

[uwreedb3]

So I have a list of colums like so:

C1 C2 C3
X A D
Y B E
Z C F

And I have a combo box made from form controls that has C1, C2, C3 etc.

What I'm trying to make work is to select C2 for example and have the results spit out like this:

Category1 Category2 Category3

A B C

In other words the C1, C2 etc represent models. Each of these models has a specific list associated it that contains items that fit into one of several generic categories. I want to select the apporpriate model and then have it place the items in the specific categories. There are a specified amount of items for each category, for each of the different models, thus I'm thinking the best way to approach this would be to say if the model is " C1" it will know to populate the first 3 rows of category 1, the first 6 rows of category 2, etc.

 

[uwreedb3]

just realized the columns don't line up in my post, bear with me momentarily

 

[Busclas]

Not sure about a combo box as I have never used them. But you could always do something like this, or maybe it will help you get on the right track. On sheet two just select cell c1 and copy the down as far as you need.This is the formula I used:=IF($A$1=Sheet1!$A$1,Sheet1!A2,IF($A$1=Sheet1!$B$1,Sheet1!B2,IF($A$1=Sheet1!$C$1,Sheet1!C2,"")))https://docs.google.com/file/d/0B-smXm7dRTkJVmNtMVUycVdPbW8/edit?usp=sharing