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. |
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 |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com