FindLatestDateTimeBySequence.xlsx

Hi there

I'd like to use VBA code to look for the latest date\time based on the previous sequence number. In the attached, 'Current' is how it's done now, and 'Desired' is where I'd like to get to. The 'Start' date of a sequence in F5 must be the highest date\time value in 'Finish' where 'Sequence' is one less than F5.

In this example, F5 is set to '2' so the 'Start' date for sequence '2' must be the highest value for 'Finish' for 'Sequence' 1 = 2/18/15 11:12AM

I'm very green on VBA so I've not attempted a solution myself