summary table that updates.....

[jcheko]

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.

 

[Fred Smith]

My suggestion is to use a Pivot Table. They are very powerful and simple to
use. More help is available here:
http://www.cpearson.com/excel/pivots.htm

Regards,
Fred

 

[Luke M]

Perhaps a PivotTable, with a summation data field?

 

[jcheko]

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?

 

[Fred Smith]

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]

WORKED GREAT...i JUST HAVE NEVER USED PIVOTS BEFORE...THANKS ALOT!

 

[Fred Smith]

Glad to hear it. Pivot tables are like chocolate chip cookies. Once you
start, you can't stop.

Fred