Hi, Paul. I think what I'd do, if I were writing a VBA program to do this, is to create a collection—let's call it Clients—each item of which is a Client object that has properties Name (identifies the client) and Rows. Rows would be another collection, a sub-collection so to speak, each item of which has a time value and text, or if you prefer a date, a time and a text.
Your program looks at the rows you selected and loads them up, row by row, into that structure. Once it has all the data it goes through the structure client by client, and within client date by date, generating the report (in whatever format you decide).
But I'm guessing you need more detail than that, or you would have done it already. Which part of the above do you not know about? Is it collections, or objects and properties, or...? Or if you don't know how to write VBA programs at all, we gotta start further back.
|