Copy Rows - Ignore duplicates

**revenge4ash89** · 01-16-2012, 09:34 AM

Hi there,

I've created a macro which will send all rows from a worksheet to another worksheet in a different workbook. Currently it will send everything from column A - Column U until there's an empty row.

I was wondering if there is a way to skip duplicate rows. So for example if the cells in row A2:U2 matched a row in the second workbook, it would skip sending that row!

Below is the code I'm using, and I've attached an example spreadsheet to give a clearer view of what I'm trying to achieve.

Thanks for any help in advance

Please Login or Register  to view this content.

**Winon** · 01-16-2012, 01:18 PM

Would it not be easier to just append the data and then remove duplicates?

**arlu1201** · 01-17-2012, 01:51 PM

I agree with Winon. You can add the data in and if there is a unique field or combination of fields, we can delete the duplicates. Its far easier and faster than checking if its duplicate and then copying.