build a pivot table from multiple other pivot tables.
Hi there,
I am trying to build a pivot table to combine the data from 10 other pivot tables, each in a different workbook. Anyone know if this possible, and if so, how to do it? Thanks, Gordo |
build a pivot table from multiple other pivot tables.
Well, I know you can use the "multiple consolidation ranges" option in the
pivot table dialog box to consolidate multiple data tables spread across worksheets. But it sounds like you want to bypass the underlying data for each pivot table, and consolidate multiple pivot tables, instead? Is there a reason you don't want to use the pivot tables' underlying data tables as your data source? Dave -- Brevity is the soul of wit. "Gordo" wrote: Hi there, I am trying to build a pivot table to combine the data from 10 other pivot tables, each in a different workbook. Anyone know if this possible, and if so, how to do it? Thanks, Gordo |
All times are GMT +1. The time now is 05:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com