View Single Post
 
Old 04-03-2014, 04:04 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote