print result based on combo boxes

[kaon]

Hi all,

I am not sure about the question has been asked before, and I foun
nothing from the this forum, so I better post the question for hel
again.

I have 2 combo boxes, namely ComboA and ComboB. ComboA contains
values: "Install", "Disconnect" and "Restore", while ComboB contain
years (1999, 2000, ...., 2005).

Currently I have 2 columns, in which each column refers to a differen
file. I want to display the data based on the choices of ComboA an
ComboB on the 2 columns.

Anyone can help me to solve this?

Thanks

 

[Nick Hodge]

Kaon

Is it imperative that you use two added combo boxes? What you appear to be
doing in filtering based on criteria. If this is the case, check out
Data>Filter>Autofilter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[kaon]

Maybe I need to clarify the problem.

ComboA is used for displaying unit price of each stock in differen
years. They are placed on the same sheet but different columns. I wan
to group them into the comboA by year, which in turn is placed onto
new sheet.

To illustrate:

1999 .. 2000 .. 2001
Item X 2 .. 4 .. 1
Item Y 1 .. 2 .. 4

.. = some more rows in between

The comboA have choices of 1999, 2000, 2001. When choice is chosen, th
corresponding unit price of each item are displayed.

Hope you get what I mean.
Thanks

 

[kaon]

Would anyone kindly give me a help?
I am in a hurry.

Thanks