I am trying to find differences between 2 super large excel sheets. I have a table in Sheet 1 and an almost identical table in Sheet 2. Sheet 2's table has cells with changed or deleted values though. I want to highlight or know about changes between Sheet 2 and 1. I found the excel VBA code below on the internet:
It almost works. The problem is that it highlights way too many cells whenever a row in Sheet 2 will have disappeared compared to Sheet 1. The code above compares the 2 sheets with respect to the content of cells relative to their position in the sheet (e.g. Cell B18 in Sheet 1 == Cell B18 in Sheet 2??). I would like it to compare the values in the 2 tables based on the ID number in the very left column of both tables. That way, if a row is deleted in the table from sheet 1 to sheet 2, I will not have all cells highlighted in Sheet 2 from that deleted row downwards.
Please Login or Register to view this content.
I attached a simplified version of my excel sheet tables. The real one has thousands of rows. test1.xlsm