i'll show an example of what i mean...

this is what i have

# of occurrences for class 1 # of occurrences for cla
2

A 4
5
B 3
3
C 3
1
... ...
...

see, i need some type of method that will allow me to hide class
while class 1 is selected, so it would look like


-----------------
| Class 1 | <- "combo box"
-----------------
# of occurrences for class 1
A 4
B 3
C 3
... ...

and then when class 2 is selected all that changes is the data...i.e.:

----------------
| Class 2 | <- "combo box"
----------------
# of occurrences for class 2
A 5
B 3
C 1
... ...

see what i mean?

it will save me a lot of viewing area, which would help me later on...
if anyone can help me with this, i'd truly appreciate it.

Thanks again in advanced!

--
younatha
-----------------------------------------------------------------------
younathan's Profile: http://www.excelforum.com/member.php...fo&userid=1541
View this thread: http://www.excelforum.com/showthread.php?threadid=27021