pivot table

[Igneshwara reddy]

Hi,

How to use two or three sheets in a single pivot table.

I have the data in multiple sheets and I require a single pivot with all the
sheets.


Regards,
Igneshwara reddy

 

[Fred Smith]

It is possible to use multiple consolidation ranges in a pivot table,
however, there are restrictions. Look here for more information.
http://www.contextures.com/xlPivot08.html

My bet is the best advice is to consolidate your data onto one sheet.

Regards,
Fred.