Use AutoFilter.

Switch-on AutoFilter on column D and select December
Copy the visible rows and paste them to Sheet3

If you want a macro to do this, just use the Recorder.
--
Gary''s Student - gsnu200821


"daisy2008" wrote:

Hello,

I really need help with this one. I need to find a variable that will be in
D11 sheet1 find it in sheet2 column D copy all the rows and paste it in
sheet3.

Ex:

December in the value in cell D11

find December in column d copy all of the rows

Number Name order date Month received order number
101085 test 11/14/08 December 12
102086 joe 11/20/08 December 15
205684 Ann 10/25/08 November 9
100852 Dave 11/2/08 December 11

then paste the entire rows to sheet3 A3

Number Name order date Month received order number
101085 test 11/14/08 December 12
102086 joe 11/20/08 December 15
100852 Dave 11/2/08 December 11


Can this be done?

Thanks Daisy :)