pivot table
 

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

pivot table
 

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.

"Igneshwara reddy" wrote in
message ...
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