HOW DO I COMPARE TWO SHEETS AND IDENTIFY WHICH CELLS DIFFER

[STEVE THE PARTS GUY]

HOW DO I TAKE DATA FROM ONE SHEET AND COMPARE IT WITH DATA FROM ANOTHER SHEET
AND IDENTIFY AND SORT OUT OR ISOLATE DATA THAT IS FOUND IN ONE SHEET BUT NOT
THE OTHER. MOST OF THE DATA IN THE TWO SHEETS WOULD BE IDENTICAL BUT THERE
WILL BE SOME NEW ENTRYS ON THE
OTHER SHEET THAT I WANT TO IDENTIFY.

[bpeltzer]

For arguments sake, suppose your sheets are MasterSheet and TestSheet, with
the key value that uniquely identifies records in column A of each sheet,
starting in row 2. In the first blank column of the TestSheet (where we'll
check for additions), enter the formula =match(a2,MasterSheet!A:A,false).
The result will be either a number (indicating the matching row from the
MasterSheet) or #N/A indicating no match. Copy that formula down as many
rows as necessary. Then select the column and Data > Filter > Autofilter and
select #N/A. The rows shown are additions, not yet on the MasterSheet.

"STEVE THE PARTS GUY" wrote:

> HOW DO I TAKE DATA FROM ONE SHEET AND COMPARE IT WITH DATA FROM ANOTHER SHEET
> AND IDENTIFY AND SORT OUT OR ISOLATE DATA THAT IS FOUND IN ONE SHEET BUT NOT
> THE OTHER. MOST OF THE DATA IN THE TWO SHEETS WOULD BE IDENTICAL BUT THERE
> WILL BE SOME NEW ENTRYS ON THE
> OTHER SHEET THAT I WANT TO IDENTIFY.