Help wCombo Box Setup

[Lance Hoffmeyer]

Hey all

I have a Main Data Tab:

COL A COL B COL C COL D COL E
R1
R2 Total Brnd1 Brnd2 Brnd3 Brnd4
R3
R4 ATT1 1.00 0.50 0.44 0.34 0.21
R5 ATT2 1.00 0.50 0.44 0.34 0.21
R6 ATT3 1.00 0.50 0.44 0.34 0.21
R7 ATT4 1.00 0.50 0.44 0.34 0.21
R8 ATT5 1.00 0.50 0.44 0.34 0.21
R9 ATT6 1.00 0.50 0.44 0.34 0.21


and then a Filtered Datatab where I
would like to put a combobox where the
items from R2 on the Main Data Tab are
listed and if selected then the data
below them is pasted into the Filtered
Datatab.

Do, if I select Total in Col C and Brnd4 in
Col D via a combobox my data would look
like this:

COL C COL D
R11
R12 Total Brnd5
R13
R14 ATT1 1.00 0.21
R15 ATT2 1.00 0.21
R16 ATT3 1.00 0.21
R17 ATT4 1.00 0.21
R18 ATT5 1.00 0.21
R19 ATT6 1.00 0.21


Do, if I select Brnd1 in Col C and Brnd2
in Col D via a combobox my data would look
like this:

COL C COL D
R11
R12 Brnd1 Brnd2
R13
R14 ATT1 0.50 0.44
R15 ATT2 0.50 0.44
R16 ATT3 0.50 0.44
R17 ATT4 0.50 0.44
R18 ATT5 0.50 0.44
R19 ATT6 0.50 0.44


I have very little experience with comboboxes.
What would I put in the code sheet for each of
the comboboxes (I would need 2 comboboxes, one
for Col C and one for Col D) so that I could
grab the appropriate data depending on which BRND
I want to look at?

Thanks in advance,

Lance

 

[Mike H.]

Without spending too much time looking at your question, it would appear to
me that what you really need/want is a pivottable. A pivottable gives you
the ability to "drill" different info out of your database and it is
extremely easy to set up. To try it, just highlight your data and select
Insert Pivottable (Excel 2007) or data>pivottable (I think, Excel 2003).
Give it a whirl....