I have a piece of kit that can be set to export telemetry data each month. this takes the form of an excel workbook and the system appends each new months data to the workbook.
We have no control of the layout and formating of the data it just out puts in its own way. So we would like to be able to use the data to automatically populate a template report with the previous months figures in a way that is more presentable to the client.
I have managed to link the two workbooks to update data but i am not sure how to only import the last months figures in a dynamic way.
I have little excel or VBA knowledge but can follow instructions. Is anyone able to help. I include an example of the data the equipment outputs.barnsley test_30min_Report.xls