You can create a pivot table from the 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

lindsayhyle wrote:
Hi,
I have a large amount of data that has to many lines for one sheet, so I had
to put half of it on a second sheet. I would like to do a pivot over both
sheets together so that i can have one pivot chart. Is this possible?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html