convert Index / Match formula to VBA

Hello.


I appear to be going around in circles with this problem.

I have Data coming from a couple of instruments. Data from one instrument needs to be linked the data in the second.
For example for each round of distance readings (all to the one location) the last time needs to be extracted and the temperature and pressure readings for this time placed in the spreadsheet.

I have got this to work with formula in the cells but I have found out that the size of the data changes and would like a macro to place the matched values into the cell.

The formula I have been using in Sheet “Trim” cell H2 is

Please Login or Register  to view this content.

I have tried to replicate this in VB with the code below. It is also contained I the macros that trims the extra reading from each round and places them in the “Trim” sheet.

the workbook is also attached.

Any help will be greatly appreciated

Please Login or Register  to view this content.