Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a Pivot Table pull data from Multiple WorkSheets ?
Hello;
I'm attempting to Pull data Into a Pivot table from Multiple WorkSheets and/or multiple Pivot Tables .... Is this possible ? Thanks, Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a Pivot Table pull data from Multiple WorkSheets ?
Not my area of expertise, but this is what is stated in Help:
About creating a PivotTable or PivotChart report to consolidate multiple data ranges When you have several Microsoft Excel lists with similar categories of data and you want to summarize the data from the lists together on one worksheet, one option is to use a PivotTable or PivotChart report. Excel also provides other ways to consolidate data that work with lists in all kinds of formats and layouts. Setting up the source data When you consolidate data from multiple lists or worksheets, the lists or worksheets must have matching row and column names for items that you want to summarize together. Do not include any total rows or total columns from the source data when you create the PivotTable or PivotChart report. Learn about setting up data in list format. Using named ranges when source data is likely to expand To make the PivotTable or PivotChart report easier to refresh when the source ranges change, name each source range and use the names when you create the PivotTable or PivotChart report. If a named range expands to include more data, you can refresh the report to include the new data. Using page fields in consolidations A consolidation uses custom page fields that contain items that each represent one or more of the source ranges. For example, if you're consolidating budget data from the Marketing, Sales, and Manufacturing departments, a page field could include one item for each department plus an item to show the combined data. Page field options After you click Multiple consolidation ranges in step 1 of the PivotTable and PivotChart Wizard, you can choose the kind of page fields you want. a.. A single page field To display a single page that consolidates all ranges from the source data, letting you display each individual range or the consolidation, click Create a single page field for me in step 2a of the wizard. b.. Multiple page fields You can create as many as four page fields and assign item names for each source data range, or you can create a consolidation that doesn't have page fields. Click I will create the page fields in step 2a of the wizard. Use this option when you want to compare partial and full consolidations. You can assign any subset of your ranges to a page field so that you can display a consolidation that includes only the ranges you assign. The text has links, so you might want to look it up in your own help file. -- Regards, Tom Ogilvy "GSears" wrote in message ... Hello; I'm attempting to Pull data Into a Pivot table from Multiple WorkSheets and/or multiple Pivot Tables .... Is this possible ? Thanks, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from different worksheets/tab into one Pivot Table | Excel Worksheet Functions | |||
Pivot Table - Can Data Range be on multiple worksheets? | Excel Discussion (Misc queries) | |||
Pivot Table - Can my data range be on multiple worksheets? | Excel Discussion (Misc queries) | |||
Multiple worksheets data to one pivot table | Excel Worksheet Functions | |||
can a pivot table pull from multiple worksheets? | Excel Worksheet Functions |