Hello,

I have a workbook which contains name, street address, city and state
in columns C to F and date in column G.
Can anybody help me in getting a macro which does the following:

1. Find duplicate, if the entire data (Column C to Column F) is
repeating.
2. Cut and Paste the entire row of duplicates into a new sheet, except
the row which has the latest date in Column G.

Is my question clear?

Any help is greatly appreciated.

-Dileep