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