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


lothario wrote:

Hi,

In my "first" sheet I have the following 3 columns of data:
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/