Hi,

I have a worksheet that contains some detailed data. I'm trying to
programatically build a second worksheet that will show a summary of that
data. However, I'm more than a little stumped.

The detailed data is in 4 columns of the form: Server, Person ,File, Size.
The summary needs to show 3 columns: Server, Person, TotalSize

I can do a little VBA, but I'm certainly no expert and would appreciate any
guidance you can offer.

Many thanks,

Simon

Simon,

Use a pivot table based on your table, with Size set to "Sum" as your data field, and Server and
Person as the Row fields.

HTH,
Bernie
MS Excel MVP


"Simon Greenland" wrote in message
.119...
Hi,

I have a worksheet that contains some detailed data. I'm trying to
programatically build a second worksheet that will show a summary of that
data. However, I'm more than a little stumped.

The detailed data is in 4 columns of the form: Server, Person ,File, Size.
The summary needs to show 3 columns: Server, Person, TotalSize

I can do a little VBA, but I'm certainly no expert and would appreciate any
guidance you can offer.

Many thanks,

Simon

Hi Bernie,

Thanks for your help - I was able to get the report just how I needed it.

However, I now need to include some summary fields from the original sheet.
For example, where someone has left the company and all their files can be
archived, the report would read Server, Person, Archive, Total Size. Do you
know a way in which this may be achieved?

Thanks again,

Simon

Simon,

How is Archive noted in the original data table?

HTH,
Bernie
MS Excel MVP


"Simon Greenland" wrote in message
.119...
Hi Bernie,

Thanks for your help - I was able to get the report just how I needed it.

However, I now need to include some summary fields from the original sheet.
For example, where someone has left the company and all their files can be
archived, the report would read Server, Person, Archive, Total Size. Do you
know a way in which this may be achieved?

Thanks again,

Simon

Bernine,

It is noted as:

Server, Person ,File, Size, Archive

abc123, Fred Bloggs, data\wastedspace\waste01.txt, 500, Archive
abc321, Jane Doe, data\usedspace\notwaste01.txt, 600, Keep
etc

The decision to archive or keep is based mostly on the person's name.
However, some files from people who have left will be marked as keep.


Many thanks,

Simon




"Bernie Deitrick" <deitbe @ consumer dot org wrote in
:

Simon,

How is Archive noted in the original data table?

HTH,
Bernie
MS Excel MVP


"Simon Greenland" wrote in message
.119...
Hi Bernie,

Thanks for your help - I was able to get the report just how I needed
it.

However, I now need to include some summary fields from the original
sheet. For example, where someone has left the company and all their
files can be archived, the report would read Server, Person, Archive,
Total Size. Do you know a way in which this may be achieved?

Thanks again,

Simon

Simon,

Select all five columns prior to creating the Pivot table, then drag the header from the column with
the Archive status to either the Row Field area or the Column Field Area. Then you will see the
status, and can choose to show just Archive or Keep or whatever you choose....

HTH,
Bernie
MS Excel MVP


"Simon Greenland" wrote in message
.119...
Bernine,

It is noted as:

Server, Person ,File, Size, Archive

abc123, Fred Bloggs, data\wastedspace\waste01.txt, 500, Archive
abc321, Jane Doe, data\usedspace\notwaste01.txt, 600, Keep
etc

The decision to archive or keep is based mostly on the person's name.
However, some files from people who have left will be marked as keep.


Many thanks,

Simon




"Bernie Deitrick" <deitbe @ consumer dot org wrote in
:

Simon,

How is Archive noted in the original data table?

HTH,
Bernie
MS Excel MVP


"Simon Greenland" wrote in message
.119...
Hi Bernie,

Thanks for your help - I was able to get the report just how I needed
it.

However, I now need to include some summary fields from the original
sheet. For example, where someone has left the company and all their
files can be archived, the report would read Server, Person, Archive,
Total Size. Do you know a way in which this may be achieved?

Thanks again,

Simon