Pivot table options

Helen · Mar 5th, 2002, 02:15 PM

Does anyone know of any good sites that give you how to use the pivot table function when you choose 'Multiple Consolidation Ranges'. I use the basic pivot all the time, but I just can't get my head around how you can create a pivot from 2 different spreadsheets/worksheets.

Thanks

Helen

[ This Message was edited by: HELEN on 2002-03-06 04:49 ]

Mark W. · Mar 5th, 2002, 02:22 PM

Are you familiar with the concept of Consolidation? If not, start by examining the Help Topic for "consolidating data".

[ This Message was edited by: Mark W. on 2002-03-05 13:23 ]

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

Mar 5th, 2002, 02:15 PM	#1
Helen Board Regular Join Date: Feb 2002 Posts: 103	Does anyone know of any good sites that give you how to use the pivot table function when you choose 'Multiple Consolidation Ranges'. I use the basic pivot all the time, but I just can't get my head around how you can create a pivot from 2 different spreadsheets/worksheets. Thanks Helen [ This Message was edited by: HELEN on 2002-03-06 04:49 ]

Mar 5th, 2002, 02:22 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Are you familiar with the concept of Consolidation? If not, start by examining the Help Topic for "consolidating data". [ This Message was edited by: Mark W. on 2002-03-05 13:23 ]