I am running a Macro which filters data into 4 separate workbooks. I
then need to copy the filtered data into the one workbook but when I do
this it is copying the full 65,000 rows. Is there something I can
record in a Macro that will only copy down to the last cell with a
value in it. The number of rows is going to change each time the macro
runs so I can't select the filtered data by itself.

thanks


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=381239