I don't see why you would have to "add fields to the pivot table". You might
have to refresh it, but that's all. I can't think of any other solutions
that come anywhere close to being as easy as Pivot Tables.

Regards,
Fred



"jcheko" wrote in message
...
the pivot table is only applicable to the "master sheet" and I wont be
able
to update it unless I add fields to the pivot table, is that right?......I
would like to have the summary table in a different sheet automatically
updating.....any other ideas?

"Luke M" wrote:

Perhaps a PivotTable, with a summation data field?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jcheko" wrote:

I need a spreadsheet that updates a master list I have in another sheet
in
the same workbook that updates itself once I have made a change to the
master
list. for example:

master list:

rcp 24" 300 lf
mh 5' 1 ea
inlet type R 2 ea
rcp 24" 50 lf
inlet type R 4 ea
mh 4' 2 ea
mh 5' 5 ea
rcp 30" 300 lf

summary list:
rcp 24" 350 lf
rcp 30" 300 lf
mh 5' 6 ea
mh 4' 2 ea
inlet type R 6 ea

and if I make a change to the master the summary should be able to
update
the add or the material I deleted....any suggestions?....thanks.