Pivot Tables with Multiple Lists

L

LPS

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,
 
J

JAA149

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

[email protected]

==============
 
Top