pivot table for multiple worksheets

[Jency]

Hello,
I need to prepare a report using Pivot, where the source of information is
not in one worksheet. Could you help me here and tell me how I could use data
from various sheets in one Pivot.

 

[Jacob Skaria]

Dear Jency

Try Pivot Table|Multiple consolidation of ranges. Incase of any help let us
know.

Refer http://www.contextures.com/xlPivot08.html for help.

If this post helps click Yes

 

[Ashish Mathur]

Hi,

As an alternative to multiple consolidation ranges, you can also use Data >
Consolidate to get all the data in one worksheet and then create a pivot
table. Data > Consolidate is well explained in the Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com