Pivot Table Data Source



I want to use multiple (just 3) worksheets to feed one report or one pivot
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?




Shane Devenshire


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