pivot

  • Thread starter Thread starter Malik
  • Start date Start date
M

Malik

hi, how can i build a pivot for data in two or more sheets in the same
workbook?
if i cant make a pivot, what are the possible alternatives to consolidate
the data.

thanks in advance.
 
You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

http://www.contextures.com/xlPivot08.html

Perhaps you could store all your data on one sheet, or in a database,
and create the pivot table from that.
 
Back
Top