We help IT Professionals succeed at work.

excel 2016 compare two worksheets in different workbooks for differences

contrain
contrain asked
on
excel 2016 compare two worksheets in different workbooks for differences. I have similar data on spreadsheets in 2 different workbooks and would like to compare them for differences.
Comment
Watch Question

Rob HensonFinance Analyst

Commented:
Need more detail; and ideally sample workbooks.

Are you comparing for existence of one record in one and not in the other?
Does each record have a unique ID that can be used?
Is each record a single row?
Commented:
I was actually able to take the data into Access and compare that way.