summary table that updates.....

  • Thread starter Thread starter jcheko
  • Start date Start date
J

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.
 
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?
 
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
 
Glad to hear it. Pivot tables are like chocolate chip cookies. Once you
start, you can't stop.

Fred
 
Back
Top