It would be most efficient to export both sets of data to
Access. Then use queries to find the sets of data you are
looking for.


-----Original Message-----
Please can anybody help me with the following:

I have two excel spreadsheets, each sheet holds the same
column
headings (25 headings)

I want to compare both sheets with a primary key (ID No:)
and then
show the records that DO NOT match. I do not however want
to do
vlookups, or if's statements because there will be approx
36000 rows
of data in each sheet.

From the records that DO NOT match I need to locate the
information
that has changed. But I only want to bring in the changes
that have
occurred, for example 1:

Spreadsheet1 - ID No:12345 DOB: 28/02/78 Grade: A
Department: Finance
Hours: 37
Spreadsheet2 - ID No:12345 DOB: 28/02/78 Grade: B
Department; HR
Hours:37

Result = ID No: 12345 DOB (blank)Grade: B Department: HR
Hours:
(blank)

Example 2:

Spreadsheet1 - ID No:56789 DOB: 28/09/82 Grade: B
Department: HR
Hours: 37
Spreadsheet2 - ID No:56789 DOB: 28/09/82 Grade: BS
Department: HR
Hours: 25

Result = ID No: 56789 DOB (blank)Grade: BS Department:
(blank)Hours: 25

Any help would be greatly appreciated, thankyou in
advance.


Rachel
.