Pivot Table Data Source
 

I want to use multiple (just 3) worksheets to feed one report or one pivot
table.
My workbook has three worksheets with similar data. On the fourth worksheet
I created a pivot table with data from worksheet 1 and works good.

How can I add data from worksheets 2 & 3 to my existing pivot table?
Do I need to create more than one pivot table to make my one report?

Thanks.

Pivot Table Data Source
 

Hi,

We need to know what verson of Excel you are using and the layout of the
data (I assume its the same data on all sheets, in the same order?) And you
need to tell us what you want your pivot table to display. Also, it would
help to know how many rows of data you have on each tab - approximately.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"evoxfan" wrote:

I want to use multiple (just 3) worksheets to feed one report or one pivot
table.
My workbook has three worksheets with similar data. On the fourth worksheet
I created a pivot table with data from worksheet 1 and works good.

How can I add data from worksheets 2 & 3 to my existing pivot table?
Do I need to create more than one pivot table to make my one report?

Thanks.