You can use MS Query and create a union query of the two data sheets so that
the data can be brought into the pivot table together.
Gary
"MRT" wrote:
I have an Excel Workbook with 2 sheets of data. Both sheets have identical
fields(column lablels). Basically, the only reason it is in 2 sheets is
because there are too many rows for one sheet.
I want to create a Pivot Table using the data from both sheets, but I want
it to appear exactly like a Pivot Table from a single sheet.
Meaning, when I create a Pivot Table of Multiple Consolidation Ranges of the
2 sheets, I do not have the same Pivot Table fields. I only have Column and
Data fields.
I want the Pivot table to have all of the fields that it would have if all
the data were on one page.
Is there something I am doing wrong? Or is it not possible to do this?
Thanks,
MT
|