Pivot Table using data from multiple sheets
 

Is it possible to create a pivot table using data from multiple sheets within
the workbook? For example, pivot sheet 1 a1-a12 and sheet 2 c1-c5.

If so, how do you do this? I keep coming up with errors.

Thank you

Pivot Table using data from multiple sheets
 

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

As an alternative, you may want to create a summary sheet, and build your
pivot table off that:
http://msdn.microsoft.com/en-us/library/cc837974.aspx

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"nabanco" wrote:

Is it possible to create a pivot table using data from multiple sheets within
the workbook? For example, pivot sheet 1 a1-a12 and sheet 2 c1-c5.

If so, how do you do this? I keep coming up with errors.

Thank you