| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summary table that updates.....
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary table that updates.....
My suggestion is to use a Pivot Table. They are very powerful and simple to
use. More help is available he http://www.cpearson.com/excel/pivots.htm Regards, Fred "jcheko" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary table that updates.....
WORKED GREAT...i JUST HAVE NEVER USED PIVOTS BEFORE...THANKS ALOT!
"Fred Smith" wrote: My suggestion is to use a Pivot Table. They are very powerful and simple to use. More help is available he http://www.cpearson.com/excel/pivots.htm Regards, Fred "jcheko" wrote in message ... 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. . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary table that updates.....
Glad to hear it. Pivot tables are like chocolate chip cookies. Once you
start, you can't stop. Fred "jcheko" wrote in message ... WORKED GREAT...i JUST HAVE NEVER USED PIVOTS BEFORE...THANKS ALOT! "Fred Smith" wrote: My suggestion is to use a Pivot Table. They are very powerful and simple to use. More help is available he http://www.cpearson.com/excel/pivots.htm Regards, Fred "jcheko" wrote in message ... 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. . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary table that updates.....
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary table that updates.....
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary table that updates.....
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Updates Issue | Charts and Charting in Excel | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
| Automatic updates of a ranked table | Excel Discussion (Misc queries) | |||
| Can I setup a league table that automatically updates itself? | Excel Discussion (Misc queries) | |||
| Pivot Table - Updates | Excel Discussion (Misc queries) | |||
Hybrid Mode
