Copy unique row from 2 workbooks

Hi guys,

I very new to excel and newer to vb and have tried fiddling around but cant seem to get it started, so i need some help with copying all unique rows to a new workbook. Ive done searches and it seems theres alot of 'compare' sheets but not books.

I have 3 work books:

• book1 = original data
• book2 = new data and some original data
• book3 = blank, will be populated once I can get this going


the result i am hoping to get is...

From wb3 i would click a button and then prompt to “select file” twice. To select book1.xlsx & then select book2.xlsx. Once both selected, compare book1 column A & book2 column A. Then all unique rows to populate next available row in book3. Also, wb1 has multiple sheets. if this is a problem i will split it up

Can someone help point me in the right direction to get this started? I’m at a loss.

Ive attached a 2 samples... if it helps. book1.xlsx & book2.xlsx

thanks in advance for any wisdom & knowledge you can share

Hi guys,

I found something & modified it to work with my query, but how do i change it so that:

• at the begining i select book1.xlsx & book2.xlsx instead of having to open them first?
  The file name may not always be the same - but the records will always be in the same formatting & locations

• instead of creating a new book, add to wb3 (current opened book where code is saved)

thanks in advance for your assistance

Please Login or Register  to view this content.