Simply use a formula on a third sheet that does a cell-by-cell comparison:
=Sheet1!A1=Sheet2!A1
then copy down & across as far as needed.
This will return TRUE for any that are the same and FALSE for any that differ, not just whether the rows are 'new'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|