Macro required to delete rows based on date

Hi

I'm completely new to VBA in Excel , appreciate that I need to do some learning but I need a quick solution to this particular problem - if anyone can help would be really appreciated

I have a large spreadsheet with date stamped data where each row has been created. Date in column 'R'. I need the last created row for a particular object (i.e. all other earlier rows need to be deleted). Each object has a unique identifier in column 'D'

So essentially based on the date in column R, I need to delete all rows except the latest one created for each unique object

Many thanks!

Hi

See how this goes.

Please Login or Register  to view this content.

rylo