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