Pivottables - Can i consolidate 2 Data sources in Excel 2007?

[Kevin Clark]

I have two tables in two worksheets in one workbook.
They have identical column headings.
Can i create one Pivottable consolidating all of their data?
I can find info for Excel 2002 but not 2007.

Thanks in advance.
Kev

 

[Kevin Clark]

PLEASE HELP. THERE MUST BE A WAY?

 

[Debra Dalgleish]

You can create a pivot table from Multiple Consolidation Ranges in Excel
2007. To open the old PivotTable Wizard, press Alt+D, and then type P
Then, follow the instructions here, to create the pivot table:

http://www.contextures.com/xlPivot08.html

 

[Zahra]

This question refers to a question I had as well. I have data spread over 6
spreadsheets. I have a problem though:

PivotTable wants me to tell him which column/row headers to display. I want
some column headers to show horizontally and some of them to show vertically,
in the same table. I don't have a problem when using data from one
spreadsheet, because I can select individual columns names and drag/drop them
in the layout. In the consolidated view, I can only select "Column" or
"Row", not "Month" or "Sales".

 

[Debra Dalgleish]

If you create a Pivot Table from multiple consolidation ranges, as you
discovered, you won't get the same pivot table layout that you'd get
from a single range. There's more information here:

http://www.contextures.com/xlPivot08.html

Perhaps you can store the data on one worksheet, and create the pivot
table from that. You may want to add a column to identify a region or
salesperson, if that's why the data is currently on separate sheets.