If it was me, I would do the following:
1. Turn on macro recorder.
2. Go to Sheet2, filter the data for the date you want.
3. Copy the data to its destination.
4. Turn off macro recorder.
5. Modify the macro the pickup the data filter from cell Sheet1!a1, and the
destination.

If you need help, with step 5, let us know. Post the macro code when you do.

Regards,
Fred

"Very Basic User" wrote in message
...
Help please... How would I get the following to occur. (Sheet 1 cell A1 =
2/22/10 when I run macro, look for 2/22/10 on sheet 2, and copy an area
from
sheet 1 to the appropriate area of sheet 2. So each time sheet one date
changes, it copys the same area of sheet one into the correct area of
sheet 2
that matches the date.
--
Thank you for your time!
John