Find Max and Min plus Date of each Max and Min using an excel script

[mickcondon89]

Hi there,

I have multiple workbooks containing the water level data for a particular bore.

So if the bore is listed 46217, it will have its own workbook and contain a series of columns listing the date the water level was taken, the water level and other details.

What I want to do is create a script that will create a separate excel file containing the max and min water level (the column labeled WLMP__m_), plus the date of each value for each bore/workbook.

There is approx 140 workbooks and I need to complete this for each one.

I have attached one of the files as an example.

Thanks,

Mick