Pivot Tables with Multiple Lists
 

I am trying to create a pivot table report whch uses data from two separate
spreadsheets (Excel 2000). Is there any way to combine two page fields into
one, e.g.; the first spreadsheet has data from the year 2000-2001 and the
second sheet has the same type of data for the years 2002-2003. I would like
to create a pivot table report which combines both year ranges into one page
field?

Can anyone help?

Thx,
--
LPS

Pivot Tables with Multiple Lists
 

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

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


LPS wrote:
I am trying to create a pivot table report whch uses data from two separate
spreadsheets (Excel 2000). Is there any way to combine two page fields into
one, e.g.; the first spreadsheet has data from the year 2000-2001 and the
second sheet has the same type of data for the years 2002-2003. I would like
to create a pivot table report which combines both year ranges into one page
field?

Can anyone help?

Thx,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Pivot Tables with Multiple Lists
 

Dear LPS,

The multiple consolidation ranges dows not work'.

Use MS Query to combine the data. Use

SELECT * FROM Table 1
UNION ALL
FROM Table 2

Save the query and use it as a source data for you piviottable.

Regards

Jawad



==============



"LPS" wrote:

I am trying to create a pivot table report whch uses data from two separate
spreadsheets (Excel 2000). Is there any way to combine two page fields into
one, e.g.; the first spreadsheet has data from the year 2000-2001 and the
second sheet has the same type of data for the years 2002-2003. I would like
to create a pivot table report which combines both year ranges into one page
field?

Can anyone help?

Thx,
--
LPS