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