Hi Team,

I am here for another help. I have two sheets named new and master. I want to check the employee data are perfect in the newly added data (i.e. New tab).

In New sheet there are 4 columns namely, Employee #, name, Address and Phone Number.

In Master Sheet there are 4 columns namely, Employee Number, Name, Address and Employee Phone # in both the sheets. (there is a difference in the headings)

First, it has to check whether the employee in new tab is available in master tab. If not it has to be highlighted in Red.

Second, it has to check whether the name has been updated correctly in the new sheet comparing to master sheet. If not it has to be highlighted in Red.

Third, it has to check whether the Address has been updated correctly in the new sheet comparing to master sheet. If not it has to be highlighted in Red.

Fourth, it has to check whether the Phone Number has been updated correctly in the new sheet comparing to master sheet. If not it has to be highlighted in Red.

Please note, there can be format changes and there could be spaces in a cell after the string. Macro has to ignore these format and spaces.

Your help on this would be really appreciated.


Thanks,
Vignesh