Here is the problem I have that you may help me to create the report I need... My knowledge of VBA is as a beginner and think this report requires much more experience and knowledge of programming. Here is the situation: I have a list of Plant Generators and a list of data info regarding the energy (KWh) delivered to the system. The info, each lecture, is sent every 15 minutes everyday. It means that in a month, let's say January, the monthly report for every generator needs to be 2,976 records (31 days x 24 hrs/day x 4 times/hr), there are 40 generators, so the list is huge (around 119k records), but I have just attached the file with a little portion as sample.
The report for every generator needs to be minimized in an hourly version adding all the kwh delivered every 15 minutes of the hour. It will be an easy task IF the records stay perfect (4 records every hour) since it would only be necessary to have a loop that adds the records every 4 times; however, sometimes a record is missing and it is when it gets complicated because you cannot add the first record of the next hour but instead to add only the 3 records within that hour and so for. At the end, a report of exception (missing records) need to be created.
I am attaching the file where I have done the programing but as a total version (not hourly), IF possible, could you help me on this? Any kind of help either programming or idea of how to do it, will be appreciated. Thanks