I have two worksheets. Worksheet 1 has payments from old system, worksheet 2 has payments from new system. I need to compare worksheet 2 to worksheet 1 and vice versa and identify (possibly by notation in 3rd column / missing from Sht 1 or missing from Sht2). I have two columns - Column A = employee #, column B = date of check. I use Excel 2010.

I apologize if this is something quite simple but I've tried vlookup, index(match formulas but they don't work so I'm hoping someone has VBA code that does this.

Thank you in advance for any help.