Prev: Open and close workbooks
Next: Named Ranges on different sheets
From: Gary Brown on 15 Apr 2010 11:00
How about a pivot table?

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"SIRSTEVE" wrote:

> Here are the fields in my spread sheet.
>
> Date
> Name
> Request Received
> Start Time
> Finish Time
> Total Time
>
> Here's an example of what I'm trying to accomplish.
>
> Let's say I need to see how much time John has spent doing research mail.
> I turn on the auto filter feature so that I can select only information
> pertaining to John. Ok. Question, how can I create a summary that will give
> me a total at the end of the report of how much time John has spent?
From: SIRSTEVE on 15 Apr 2010 11:12
How do I create a pivot table?

"Gary Brown" wrote:

> How about a pivot table?
>
> --
> Hope this helps.
> If it does, please click the Yes button.
> Thanks in advance for your feedback.
> Gary Brown
>
>
>
> "SIRSTEVE" wrote:
>
> > Here are the fields in my spread sheet.
> >
> > Date
> > Name
> > Request Received
> > Start Time
> > Finish Time
> > Total Time
> >
> > Here's an example of what I'm trying to accomplish.
> >
> > Let's say I need to see how much time John has spent doing research mail.
> > I turn on the auto filter feature so that I can select only information
> > pertaining to John. Ok. Question, how can I create a summary that will give
> > me a total at the end of the report of how much time John has spent?
From: Bernard Liengme on 15 Apr 2010 12:19
See my reply

"SIRSTEVE" <SIRSTEVE(a)discussions.microsoft.com> wrote in message
news:69E80B10-AE4D-42E1-A08E-AA158D4A983C(a)microsoft.com...
> How do I create a pivot table?
>
> "Gary Brown" wrote:
>
>> How about a pivot table?
>>
>> --
>> Hope this helps.
>> If it does, please click the Yes button.
>> Thanks in advance for your feedback.
>> Gary Brown
>>
>>
>>
>> "SIRSTEVE" wrote:
>>
>> > Here are the fields in my spread sheet.
>> >
>> > Date
>> > Name
>> > Request Received
>> > Start Time
>> > Finish Time
>> > Total Time
>> >
>> > Here's an example of what I'm trying to accomplish.
>> >
>> > Let's say I need to see how much time John has spent doing research
>> > mail.
>> > I turn on the auto filter feature so that I can select only information
>> > pertaining to John. Ok. Question, how can I create a summary that
>> > will give
>> > me a total at the end of the report of how much time John has spent?

First  |  Prev  | 
Pages: 1 2
Prev: Open and close workbooks
Next: Named Ranges on different sheets