Compare two tables

Hello,

I have a problem with comparing two tables. The problem is as follows: I have two sheets in Excel, 1 with the the administration up until august and one with the administration up until september. What I want to do is compare these two sheets (per row not per cell) and generate a new sheet with the differences between the two. I have a program from Ablebits data to compare two tables but this program has one problem when comparing the tables. The problem is that if a certain row occurs two times in sheet 1 and one time in sheet 2 it deletes all 3 of the rows instead of leaving one in sheet 1.

Please find attached a sheet as an example. In short I want to compare the two sheets and have 1 new sheets which shows me all the differences between the two (on a row level).

Thanks in advance for your help.

Marald

Thank you very much!! This was exactly what I was looking for!

Hello,

Just another question, when I use the macro provided before it gives me a few errors (please see attached file). Could someone help me with resolving these issues. For one Excel takes EUR 192,144 and turnes it into 192.144,00. I understand that it has something to do with the US/EUR way of using point and commas in numbers but switching my excel from EUR to US does not resolve the problem. Thansk in advance for your help.

Kind regards,

MaraldExample 2.xlsm

Thanks for your quick reply! I have tried convert the cells to Euros but this does not work. Any other tips?