PivotTables
Posted by Kirsten on July 20, 2001 6:15 AM
I am having a difficult time trying to get a summary of information from 4 pivot tables which are in separate worksheets. How do I do this?
Posted by Mark W. on July 20, 2001 6:18 AM
Please describe the desired summary and the
construction of each PivotTable.
Posted by Kirsten on July 20, 2001 6:32 AM
I have 4 pivot tables (by department) in separate worksheets that tells me in Project Category BTI (out of 3 types of categories) within each Project Phase(5 or more types of phases) how many are on in a particular status. Now that I have it broken out by department, I need to total them all up. I would be happy to email the excel file to you if that would help.
Thanks!
Posted by Mark W. on July 20, 2001 6:36 AM
Are the 4 PivotTables created from the same data
list?
Posted by Kirsten on July 20, 2001 6:39 AM
The 4 pivottables are taken off of separate worksheets. Are the 4 PivotTables created from the same data
Posted by Mark W. on July 20, 2001 6:56 AM
Do you mean to say that the 4 PivotTables are sourced
from data on separate worksheets? If so, can the
data lists be combined? The 4 pivottables are taken off of separate worksheets. : Are the 4 PivotTables created from the same data
Posted by Kirsten on July 20, 2001 7:07 AM
Yes, I do mean that the 4 PivotTables are sourced from data on separate worksheets. Unfortunately I cannot combine the 4 worksheets since they are separated by department. I could put them all together in one worksheet, but when I get the updates from each department I would then have to make the updates in two places, one on the separate worksheets and then again on the combined. Thoughts! Do you mean to say that the 4 PivotTables are sourced
Posted by Mark W. on July 20, 2001 9:12 AM
Okay... You may be able to employ consolidation.
Take a look at the Excel Help topic for "About
creating a PivotTable to consolidate multiple
data ranges". Yes, I do mean that the 4 PivotTables are sourced from data on separate worksheets. Unfortunately I cannot combine the 4 worksheets since they are separated by department. I could put them all together in one worksheet, but when I get the updates from each department I would then have to make the updates in two places, one on the separate worksheets and then again on the combined. Thoughts! : Do you mean to say that the 4 PivotTables are sourced
