Compare and Copy unique data between 2 workbooks

Hi Experts,

I started working on a macro that needs to compare and copy unique data from selected row between 2 workbooks. The workbooks have identical headers but only one column should be compared *coulmn C (header named: Invoice Number). So, I will have a Master workbook which will be regulary updated (with new invoices), and other workbooks from where the data will copied. A comparison should be made between master.xlsx and new.xlsx, and if the invoice number is not in the Master.xlsx, than the entire row should be copied from the new.xlsx workbook (sheet1 both).

I should put a Button on the Master slide, and when clicking it, the data should be compared and transferred.
Attached I am sending you the both workbooks.

Any ideas? I would really appreciate your help.

Regards,
Pucval

Just to add...

I am currently using this code, but I want to make it other way around....
This only selects and copies all rows, and I need to filter only the unique ones. I don't know what is wrong ///

Any help?

Here is the code that I am using:

Please Login or Register  to view this content.

Ok so here is the code.
I did notice something though
If you search the column C for the number and it is not found it copyes the entire row from new to master.
But the codes that are already in the master workbook don't get updated if any other value is changed in this case Bemerkung column is different for some numbers in master then in new.
Just a thought

Code:

Please Login or Register  to view this content.

Well my code works when bouth workbooks are opend.
You insert this code into VBA for master workbook.
If you want the master workbook to open the new file then you need to add the code at the top after Dim r As Range

Please Login or Register  to view this content.

arlu1201, it doesn't seem to work or I am making something wrong... My idea is only to add the new data from the first empty row and fill with data below. Precisely, if 25 is the first empty row, then add the new records below. The calendar date does not matter from columns A and B.

I will also need to run additional task connected to this macro. I hope you can give me some help and I can complete my automation process. In the end, I will go through it step by step in order to learn every single code

So:
The Column L is reserved for comments (in the header it's: Bemerkung/Beschreibung). The code needs to check if there is any data in every cell from Column L, and if it's TRUE, the entire row should be transferred to Sheet2 (Tabelle2 in my file), and should be deleted from the master slide (Tabelle1). When the data is transferred to Sheet2 (Tabelle2), it should also be transferred to a new workbook (commented.xlsx) as a backup file.

Note: this can be added as an additional module and I can create one more Control Button to run it.

Thank you in advance my saver!
Pucval

I created new thread regarding my first post, thanks..

Regarding the sorting, no it does not work. It copies the data randomly, I cannot find the right order. Is it possible just to copy the new rows on the bottom of the table, the first empty row?

Thanks,
Pucval

But, there is no order when it copies the data. Maybe because the column B is not formated as Date? It is just a simple string..

If you can change the code with just copying the new data at the first free row below, that would be great!

Tnx,
Pucval

Works beautiful! Thank you! Thank you! Thank you!
We are still left with the other thread http://www.excelforum.com/excel-prog...70#post2940570 ,
but I can mark this one as SOLVED

Regards!
Pucval