If it was done using an Autofilter then

activesheet.Autofilter.Range.Copy _
Destination:=Worksheets("Sheet2").Range("A1")

Only the visible rows are copied.

--
Regards,
Tom Ogilvy


"sungen99" wrote in
message ...

I have been able to filter my data by date but now that the filter is
done I need to copy that from one sheet to another. The problem is the
range will be dynamic so I don't know how to do it. I usually will just
record a macro and look at it. but this just takes the actual range not
the dynamic range.

thanks very much


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=378066