Code to Remove Duplicates from Rows but Retain Latest Record

[hammer2]

Hi Folks

I require Code to remove complete rows from Col I that are duplicates.
However I need to retain the latest record of each.

Example Workbook attached.

Cheers
hammer

[humdingaling]

First google search yielded this
http://www.mrexcel.com/forum/excel-q...ast-entry.html

you only needed to change the column reference from 1 to 9

[AlphaFrog]

• Sort on the dates descending in column C so the most recent are first
• Use the Remove Duplicates function to delete duplicate rows and keep the first occurrence.
• Sort the dates ascending in column C to return them they way they were.

These three steps can be recorded in a macro.

[hammer2]

@humdingaling
Thanks for the pointer- my problem is, whilst I can search for similar Code I never know how to adjust it to suit my specific requirement. I am the original Dummy- the one they wrote books for

@AlphaFrog
These simple steps prove what I just stated above- I am a Dummy

Thanks to you both for replying-
Cheers
hammer

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[humdingaling]

@ Hammer

i'm guessing you didnt finish the dummies guide then

http://www.dummies.com/how-to/conten...-2016-vba.html

[hammer2]

Thanks to YasserKhalil for the Code

Correct hummer.... I'm a Dummy at everything

[YasserKhalil]

You're welcome. Glad I can offer some help
Thanks for the feedback and for rep points

[krizcola]

Hello, I have the same problem but my question is, how can add this code to an existing code?

Thanks in advance,
Cris