pivot table for multiple worksheets
 

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.

pivot table for multiple worksheets
 

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
---------------
Jacob Skaria


"Jency" wrote:

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.

pivot table for multiple worksheets
 

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

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