Pivot Tables with Multiple Lists

[Guest]

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]

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 here:

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

 

[Guest]

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

(e-mail address removed)

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