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