Is it possible to usea macro to look at every row on a sheet and if an
row matches another on the same sheet (for example if row 3 is matche
in row 717) the second row is automatically deleted and copied to a ne
worksheet - to allow review of duplicates at a later time.

It is possible that there will be more than one duplicate, ie row 3 i
matched by row 717 and row 999 and both of these duplicates should b
carried to the new sheet.

Thanks for any hel

--
Message posted from http://www.ExcelForum.com