vba to parse a large spreadsheet and only keep the most recent occurance column b

[john.tm]

i have some large reports that i get each day and have to sort into date time order and only keep the newest occurance based on column 2

at the moment i have a vba that converts the list to space delimetd columns, then selects all sorts into date time order, then deletes dupliactes as of column 2 keeping the most recent,

is there a more efficient way just to keep the most recent occurance and removing the rest

example file. so the 2nd row would be what i am left with

0 zztimrdevappg01 t bb zz 02/26/2014 19:04:30
3 zztimrdevappg01 t bbb bb 02/27/2014 02:04:31
8 zztimrdevappg01 hh bb zz 02/26/2014 19:04:32
0 zztimrdevappg01 hh bb bb 02/26/2014 19:04:34

many thanks

[tigeravatar]

So if that data is space delimited and the data starts in column A, the date would be in column F and the time would be in column G. Couldn't you just sort by column F and G descending, then delete all but the first row?

[john.tm]

Hi thanks for your reply
the file contains hundreds od different names in column 2 not just one like in the example

[tigeravatar]

Do you get the data in a text file? When the macro starts, should it ask you which text file to import the data from? If so, give this a try:

Please Login or Register  to view this content.

[john.tm]

hi
The data is imported from outlook, then converetd from text to columns, then sorted as you have done by column b then colulmn f and g.
i tried your code but unfortunately it froze up
regards john.tm

[tigeravatar]

I'd have to see a sample file. I can tell you that the code does work given the information I've been provided. It may just take awhile to run.