Delete duplicate rows, but keep the cell that has the latest date

Hey there,

I have VBA codes to delete rows that have duplicate values in column D, and only keep rows that have the highest number value under column J. The problem that I've ran into is that column K contains different dates for each duplicate and the dates (latest) that I need to keep end up being deleted along with the unwanted duplicate rows. Is there anyway to delete the duplicate rows but only keep the cell that has the latest date in column K? TIA.

Please Login or Register  to view this content.

Bump for peeps back from lunch breaks

The only file I currently have contains my company's proprietary information. When I have some time later on, I'll try to upload an example. Thanks.