Dynamically display subset rows from one sheet in another sheet?

[lothario]

Hi,

In my "first" sheet I have the following 3 columns of data:

Person Date Choice
a 1 z
a 1 y
a 2 z
a 2 y
a 3 y
a 3 y
a 3 y
b 1 x
b 1 y
b 2 x
b 2 y
b 5 w
b 5 z
c 2 z
c 3 x
c 4 z
c 5 w

In the "second" sheet I want to:

Step 1. Ask the user to enter one Person and one Date.

Step 2. So if the user entered "a" and "2" then I would display:
a 2 z
a 2 y
In the "second" sheet as the results.

Step 3. Allow the user to clear his Person, Date and results.

Step 4. Do another search by going to Step 1.


My questions:
What is the easiest way to do this?
Can you give me the macro for this?


Thanks,

Luther

 

[keepitcool]

easiest?

make a PivotTable. No code needed.
Excel will do it all for ya!


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Chrissy]

Or set the auto filter on the first sheet and do not even use
the second one.

The used will just select what they want from the drop down
options on the columns of the auto filter.

Use the menu Data --> Filter --> Autofilter

Chrissy.


keepitcool wrote