VBA To Compare and Highlight Cells that were missed out

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??

Can anyone help me out! please...

I just wanna know if this is possible or not... can someone please reply??

It is fairly easy to highlight the cells that don't match, but to highlight the specific characters that don't match is actually quite a complicated job. Can you explain how this will be used? We might come up with an approach that is easier to do but still meets your business requirements.

Hi,

Thanks for replying!
Actually we already have a big database of Addresses of our customers in our software.. and all these addresses were updated by each customer in a form that we had provided them.
Few people were assigned to update these addresses in an Excel sheet and they had to update and manually highlight the changes which they did. This excel would then be directly uploaded in software.

Now a lot of them have made mistakes in highlighting the changes.. they have made changes but have forgotten to highlight, and now we have to find the missed out highlights and update the excel... there are many sheets with over 50K or 80K lines.

Our manager doesn't want us to replace the existing highlights. They want it to be as it is.

For the next project I have already got a macro done that would highlight the differences.. (thanks to Excel forum!) so that no manual work is to be done.. People will simply update the address or any other data and the macro will do the job of highlighting the differences.... but... for the existing problem I really need a solution... please help!

I'm trying to understand why you need each individual character to be highlighted if you already the complete correct address information.

Hi,

Okay.. the purpose is our team wants to know how many changes we have found in the updated list...
Each person who has updated the data, fills in their name at the end of the column with a remarks column that says what difference they have found in the address.. like Address changed (from one area to another) or Shifted to so and so... from one city to another or Mobile number changed / updated etc. etc... whatever changes they have found in that particular line.. they have to mention it in remarks column.

In sample book I have given only 3 or 4 columns... but we have 31 columns...where address 1,2,3, county, state, mobile no., email ID etc... are given.
Our team will analyze what amount of difference have we found in data... like how many mobile numbers were updated or changed? How many have shifted to another city? etc. etc... it's for their analysis purpose.

And one more reason is that they want to know how many of them have wrongly entered the data.
We have list of Workbooks with addresses from different cities. If in City A a person has updated saying Shifted to City D, then that entire row will be shifted in City D workbook.

The reason for highlighting the differences is that they want to know the amount of changes that took place.... and whether they should continue doing this exercise in coming years too!

Hope I have explained my situation well enough.

Amazing!!!
This is what I wanted...!! It's perfect!
Thanks a lot..... you have really saved my time!

Excel Forum Rocks!

Thank youuuuuuu!!!!