Pivot using three sheets

  • Thread starter Thread starter Neeraj
  • Start date Start date
N

Neeraj

I use Pivot table (Excel 2000) regulary for summarising my
data.
Now my data is spread over three sheets. How can I include
the data from all the three sheets in one pivot table.
Because as I understand, the Pivot table can include only
values only from one sheet. Please guide me.
 
On the very first step towards creating a pivot table, instead of just hitting next, take a look
at the multiple consolidation ranges option.
 
As others have suggested, you can create a PivotTable from multiple
consolidation ranges. However, you won't get the same pivot table layout
that you would from a single range.

If customer is the first column in your data source, the row heading
should show the customer names. If remaining columns are Units Sold,
Product#, Unit Price and Total, the column area will show each of those
headings. You can change the function that's being used by the data
value, but it will use the same function on all these columns.

The Pivot Table would contain some meaningless data, such as sum of
Product# or columns full of zeros for database columns that contain
text. To avoid this, you can rearrange your database columns, and then
use data ranges that only include the columns that you want to total.

If possible, move your data to a single worksheet, and you'll have much
more flexibility in creating the pivot table.
 
Back
Top