I've been doing a lot of research to try to understand as i go along, trying to achieve a small memory footprint, I'm currently stuck in finishing this up.
I'd really appreciate if someone could help me minimize creating extra lines and doing this the most logical way
In short- I have a report in which we fill 17 columns per row of data. Each row stands for 1 hour.
Step 1 is to determine if the cell is empty and if the hours does not exceed current system time
storing the hours into an array,
--Open data las file into it's own excel workbook
Step 2- Looping array and feeding into criteria using each hour as the initial criteria then either using the next value in the array/loop as the ending criteria to find the span of data
-While Looping each hour, the span of visible cells (1-2am) would be applied with average,max,min to respective fields then stored into array
Step 3- Position of the first hour, would allow for array to dump onto sheet
---- All of these steps to create a easy to use, friendly report, to share with others to cut down on entering data that is already being recorded. The effort of going out the way is to assume nothing except that the user has all of the columns within their las in a particular order.
Any help would be great, as my mind is swamped from trying to interpret and apply examples for the moment.
Please note- the data i work with and the excel worksheet has info that is confidential to each well we are a service on. So if i must, i can try to provide samples of the sheet and data to an extent
Links of other forum's posted on:
http://www.mrexcel.com/forum/excel-q...lete-code.html
http://www.ozgrid.com/forum/showthread.php?t=191551
Bookmarks