Export rows to another workbook but check for duplicates

Hi There,

I'm currently trying to send a range of data from a worksheet to another worksheet in a different workbook. However the code I'm using is only sending the top row, is it possible to send all rows?

I'm also trying to avoid sending duplicates. So if there is a matching row in the workbook it's being sent to the information won't be sent again.

The code I'm using is:

Please Login or Register  to view this content.