Part 1 at: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26417224.html
calacuccia's solution to Part 1 worked rather well and I'm grateful for his efforts.
In the updated Excel Workbook file (Attached: Report Solution1.wks) when running the MakeSummary routine:
When the Summary page encounters a large hourly number (Row 87 I87:65:31:32) we encounter a Runtime Error '13' Type Mismatch (see image).
On the solution in Part 1 we didn't have any large numbers so everything worked perfectly based on that example. Not so with the new larger hourly number.
Am I correct in assuming that these routines will accommodate reports that span as many months as I have data for? For example, will a 120 day report with 5000 lines need to be treated any differently?
As for the Timeline Sheet, it worked perfectly, but I have the following requests:
1. Computers be sorted alphabetically A - Z from Left to Right across the Top Row
2. The Time formatting is showing as a time AM vs. a Duration as it is in the Summary Sheet because the values are /24. I'd prefer to have the /24 so the cell formatting is standard between the Summary Sheet and the Timeline sheet if possible.