Cannot delete the duplicates on date criteria

[kwik98]

Search a column (ColumnC) for duplicates and if found use the dates in columnE to keep only the newest row and delete the other or others.Data starts in row 2 column A. and keeps building(endless rows) Mac

[venkat1926]

your data is in sheet 1. it is better not to delete the rows in sheet1 thus messing up with your original data. . but the resuting data after deleting rhe unwanted rows is better pareked in sheet 2. That is what the macro test given below does. CHECK THE RESULTS IN SHEET 2

The sample data is like this in sheet 1(A1 to E7).
the sample data you can dowanload from this url

http://www.speedyshare.com/files/22966174/kwlk98.xls


. the macro takes into account dynamic data , that is more or less rows.



the second macro undo clears sheet2 for rechecking the macro "test"

the macros are:

Please Login or Register  to view this content.

Please Login or Register  to view this content.