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