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
Bookmarks