Pivot Table Data Source

E

evoxfan

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.
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single Filter to change all Pivot Tables in a Workbook 8
One pivot table for multiple worksheets/tabs 2
Pivot Table Data Source 1
Pivot Table Update 3
pivot table data 2
pivot table multiple worksheet source data 2
Multiple Pivot Tables from Same data source 1
Pivot Table 1

Top