I do several monthly reconcilements in which I compare a spreadsheet
generated off of our HR system with invoices sent to us by vendors. One of
the tasks I do is to compare the spreadsheets to find adds/deletes on one
spreadsheet or the other. The way I'm currently doing this is by sorting the
two sets of ID numbers and putting a simple if/then statement between them,
like this:

Our ID | Comparison | Their ID
0001 | True | 0001
0002 | True | 0002
0003 | False | 0004
0004 | | 0005

After finding the first false value, I would then insert a blank cell on the
right side of the sheet, so that the values line up again, paste in the
formula again, and repeat until I've reached the end of the spreadsheet.
(Usually anywhere from 800-2000 lines). Then I copy the cells that show a
discrepancy and paste them on to a new worksheet as adds or deletes.

So my question is, is there any way to have excel compare these two
worksheets for me and kick out the discrepancies onto a new worksheet? (Or
even just compare the entire sheet without manually entering new rows?)

Thanks in advance for any help!