Excel 2007 : Filter row - copy it - and paste at the end of empty row on another work book.

Hi all,



I am using a macro to filter out records based on a value on one of the column in book 1.

I will manually copy the filtered rows and paste in to another worksheet in book 2.

Say on Day 1 I have copied 55 rows to book 2,

on day 2 I will copy for eg. 65 rows and paste below the above copied rows on day 1.



Since I am doing this every day, I need to find the last empty row and paste the filtered rows.

Can macro help to find the last empty row and paste the filtered rows on to book 2.

Please help.

Thanks.

NM.