Generating / exporting a report summarizing info in a worksheet
I don't even know if this is possible, let alone how one would achieve it. Any insights would be gratefully received!
I regularly use an Excel table spreadsheet to record information. Clients are listed in column C, and dates are listed in row 3. The data that I enter consists of (i) a value entry (time spent) in a cell itself, and (ii) a text string in a comment on that cell.
I'd like to be able to generate a report that summarizes the data as follows:
Client A
[date] | [time] | [text string]
[date] | [time] | [text string]
Client B
[date] | [time] | [text string]
[date] | [time] | [text string]
Ideally, I'd really like to be able to run the report only on selected cells, so that I could select cells within a particular period of time, and generate the report only for that information. It doesn't matter to me whether the report is another worksheet, a text file, or something else.
Hoping to hear some words of wisdom!
Thanks in advance.
|