Hi Woolstar,

You can probably do it without a macro. Assuming your column has aheader row:
• In F2 insert =A2&B2&C2&D2&E2
• In G2 insert =COUNTIF(F$1:F2,F2)
• Copy both formulae down to the last row.
• Copy column G and paste it as values (via Paste Special)
• Sort the worksheet data by Column G. All unique and 'first occurence' records will now be grouped together with a value of 1 in column G, whilst all duplicates etc will have a value of 2 (or more).
• Simply cut & paste the duplicates etc to the other worksheet.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]