Hi,
I have attached a Sample Workbook, wherein there are 2 Sheets.
Sheet 1 is with the Original Data and Sheet 2 is the data that we have received, where a person has manually highlighted the differences.
The problem is that few differences haven't been highlighted. They are missed out.
We have around 20-25 Workbooks with 25K or 50K lines in each.
Can someone help me out with a macro that can highlight the pending differences in other color without highlighting the changes that are already done??
Bookmarks