View Single Post
 
Old 05-27-2018, 10:49 PM
paulkaye paulkaye is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default 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.
Reply With Quote