Trying to compare two worksheets

[lhernandez]

I have two worksheets (sheet1 with approx. 600 lines and sheet2 with approx. 900 lines) Column C has a key number.
Is there an easy way to compare these two worksheets by the key number, and the ones that do not match any key number then copy and paste it onto a new sheet?
Any help would be great

 

[Joe4]

I think the easiest way to do it is to use Microsoft Access. They even have a Unmatched Query Wizard that walks you through all the steps to do it. And if your data is in Excel, you probably won't even need to import it into Access, you can simply link the Excel files to Access tables.