Pivot table options

[Helen]

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.]

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