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