NEED HELP HOW TO COMPARE TWO WORK SHEETS AND IDENTIFY THE DIFFERENCES.
@ROMESH1900 you can use one of the below functions:VLOOKUPHLOOKUP
MATCH along with INDEX
You can share your file if you need further help
Why don't you use the 'Inquire' com-addin that's built especially for that?