Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

2 sheet Pivot Table

Posted by Jaime on February 29, 2000 7:58 AM

Can i create a pivot table that reads data from 2 sheets. I tried using the multiple consolidation option but it does not give it to me in the format i want.

Re: 2 sheet Pivot Table

Posted by Mark on March 02, 2000 9:04 AM

Jaime

Excel has a Help screen section that addresses this.
Pull down the Help menu and select Contents and Index. Then select the Index tab and enter "PivotTables", then select "creating", and then select "About creating a PivotTable to consolidate multiple data ranges".

Mark

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.