Hi everyone
This is the first time I have posted on a forum regarding excel as I haven't really had to use it, save for some basic school and university macro work which I now cannot remember a whole lot of.
I am dealing with a 38 identical spreadsheets which are updated every few days manually, and some by a code. Each Spreadsheet is a fixed style that was purchased off a gas analysis company, and displays data from gas samples taken in an underground coal mine. The data is dropped into excel via a macro that asks for the matching file, a weird reader file that a gas analysis machine spits out (hundreds of them, one per gas sample).
I am creating a totally seperate spreadsheet that I will ideally, be able to type into a date button a date range, say, 7 days or so, and then have data for the required gas values (Nitrogen, oxygen, Carbon Dioxide, Methane, Carbon Monoxide Raw and Carbon Monoxide Air Free) values pop up from each of the spreadsheets.
For example, spreadsheet MG104 B32ct. That is a codename for one of the underground roadways, and the gas sampling point there.
There are 37 similar code names. For this roadway, the spreadsheet contains a varying amount of gas data values, and after it is manually loaded again every few days, the new spreadsheet I am trying to build will display the above gasses for that week, for all 38 roadway gas points.
I have uploaded a copy of the original spreadsheet and example of some data that it holds. I chose MG104 B32ct.
I have then uploaded a copy of a basic idea of what I want to achieve... with the simpler spreadsheet showing data for a recent week that I just went through and manually inputted the data for a report.
I realise this is a huge first post and probably quite technical, but I just feel it is relatively easy if you know how! A date range search, then spitting the data range range data for that row back into the newer spreadsheet.... sounds easier than it is im sure haha!
Even a starting point would be of much help..
Thanks a lot community!
Mitch,
Australia
Bookmarks