thank you jindon, that is great

It is almost there. For those rows that have a value of "TBC" in Col D, I need to keep the row that has the largest value in Col H only. E.g. the values could be as follows:

25/05/2016 3:45:02
25/05/2016 3:45:12
25/05/2016 3:45:01
25/05/2016 3:45:07

In this case I only need to keep the row with the 3:45:12 value as it is the largest.

Can the code be adjusted to reflect this?

Thanks again.