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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/