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

Kind regards,
Juan
easycapitalAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor 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.
0
 
helpfinderConnect With a Mentor IT ConsultantCommented:
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
0
 
easycapitalAuthor Commented:
Thanks!
JP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.