compare two spreadsheets and identify records that have any change
 

compare two spreadsheets and identify records that have any changes.
For example comparing two spreadsheets with the same specific employee
information such as first, middle and last name; employee number etc. and
only identifying records that have changes.

How about doing a vlookup from one worksheet to the other. If the value is
N/A, you know the record has changed on the other worksheet.
HTH,
--
Gary Brown



"brenped" wrote:

compare two spreadsheets and identify records that have any changes.
For example comparing two spreadsheets with the same specific employee
information such as first, middle and last name; employee number etc. and
only identifying records that have changes.

Use the = exact formula for comparing. You can then filter the colums for
all the false information which will tell which cells have been changed. I
sometimes also use =index and =match in order to find data matches.

"brenped" wrote:

compare two spreadsheets and identify records that have any changes.
For example comparing two spreadsheets with the same specific employee
information such as first, middle and last name; employee number etc. and
only identifying records that have changes.