| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot table using different worksheets/same workbook
I need to know if there is a way to create one Pivot Table for multiple
sheets in a workbook. For example, I have separate sheets for each month for a sales report and would like the Pivot Table to show the totals for the entire year. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot table using different worksheets/same workbook
You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want. There's more information he http://www.contextures.com/xlPivot08.html Mellie wrote: I need to know if there is a way to create one Pivot Table for multiple sheets in a workbook. For example, I have separate sheets for each month for a sales report and would like the Pivot Table to show the totals for the entire year. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Linear Mode
