VBA: Create unique list based on latest entry in list

I have a sheet which has 3 cols of data. Lotid, Yield(Yld), Test_date.

For any given "date" I only have a single lotid. HOwever, i want to generate a list of
lot-ids and their yield with the latest test date.

See enclosed file......i try to show an example.

I am trying to do this in VBA........