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.
Bookmarks