Pivot multiple ranges?

emills · Apr 24th, 2002, 08:31 AM

Is it possible to pivot multiple ranges on several tabs in the same workbook?

Mark W. · Apr 24th, 2002, 08:46 AM

Yes, that's what the "Multiple consolidation ranges" option at Step 1 of 4 in the PivotTable wizard is for. However, you need to understand that this feature is intended for the consolidation of 1 or 2-dimensional data tables with common row and/or column labels. The Consolidation feature existed long before PivotTables. I'd recommend that you "bone up" on the concept by consulting the following Excel Help Index topics...

1. Consolidate data

2. Guidelines for specifying source areas for a consolidation

3. About creating a PivotTable to consolidate multiple data ranges

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 08:31 AM	#1
emills New Member Join Date: Apr 2002 Posts: 1	Is it possible to pivot multiple ranges on several tabs in the same workbook?

Apr 24th, 2002, 08:46 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Yes, that's what the "Multiple consolidation ranges" option at Step 1 of 4 in the PivotTable wizard is for. However, you need to understand that this feature is intended for the consolidation of 1 or 2-dimensional data tables with common row and/or column labels. The Consolidation feature existed long before PivotTables. I'd recommend that you "bone up" on the concept by consulting the following Excel Help Index topics... 1. Consolidate data 2. Guidelines for specifying source areas for a consolidation 3. About creating a PivotTable to consolidate multiple data ranges