We help IT Professionals succeed at work.

Creating 1 pivot table from 2 ranges (each on a separate sheet)

easycapital
easycapital asked
on
Kind regards,
Juan
Comment
Watch Question

helpfinderIT Consultant
Commented:
the best way is to have 1 table from which you can create a pivot.
So in that case merge two tables into one (e.g. on 3th sheet) and use this table as data source for pivot should be elegant solution.
also you could try to check this, maybe will be helpful for you:
http://office.microsoft.com/en-us/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
You can create a pivot table from two sheets (assuming they have the same fields) by specifying a consolidation range as the data source in the first step. Then add the two data ranges.

Note that pivot tables built in this way are more limited in terms of structure, so I would agree that you should really consolidate the data onto one sheet instead if you can.

Author

Commented:
Thanks!
JP

Explore More ContentExplore courses, solutions, and other research materials related to this topic.