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.