Comparing two worksheets
 

I have seen that there are already other discussions regarding this and
I have gone through quite a few but couldn't quite make sense of it or
use the assistance provided there.

I have two worksheets. They have multiple columns and I need to compare
the two sheets to look for any data thats missing in either sheet or
any row that has different info for an employee and then highlight
where the difference is arising. Can anyone help about me with this?
Thanks in advance.

Comparing two worksheets
 

You're gonna use the "Window" dropdown.

WindowNew Window. Click the other sheet that you want to view at the same
time. Now, WindowArrange. Pick the one you want! I usually use tiled.

Hope that helps you.

"Spartan" wrote:

I have seen that there are already other discussions regarding this and
I have gone through quite a few but couldn't quite make sense of it or
use the assistance provided there.

I have two worksheets. They have multiple columns and I need to compare
the two sheets to look for any data thats missing in either sheet or
any row that has different info for an employee and then highlight
where the difference is arising. Can anyone help about me with this?
Thanks in advance.