kEEP NEWEST ROWS AND DELETE OLDEST ONE IF

Dears good afternoon

I would like to kindly ask, if someone can help me to create a vba to do the following operation :
Base on the number on column "H", I need to find on column "V" what is the newest date and then delete the others (the oldest one)

I have actually a sheet with 66000 rows and I need to delete what i do not need.
File attached, I have 96 rows for the same number on column "H".
After deleting the oldest entries in column "V" it will remain only 16 rows

If some can help me, I will be very grateful

In advance thank you

Updating.
I found a code that can meet my request but it is still missing things :

Please Login or Register  to view this content.

This code is good but I need to improve it.
I need :
* to consider booking (H) AND container Number (I) AND Seq Number (A)

Actually the code is only considering the booking number (H)

If someone can help me I will be grateful
Regards

up on this post.
I tried several ways this week end but found nothing.
Can someone help me ?

In advance thank you

Dears good morning,

Would like to inform you that I found a solution.
Let me explain it.

My first problem was to find a way to consider three values.
What I did, was to concatenate all the information.

Once I had the concatenate, I was able to use a macro (see below).
The following do the following thing :
* Filtering columns, find duplicate values in the concatenate and then delete all the oldest value (based on the date)

Please Login or Register  to view this content.

I hope it will help some one.
thank you anyway

Regards