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


MarkM wrote:
I have a question regarding the data range used to create a pivot table. Can
I use data on two different tabs of my workbook to create the pivot table.
For example, the data will come from Sheet1$A$1:$L$30000 and
Sheet2$A$1:$L$45000. I have an export of a full years worth of transactions
totaling around 75,000 rows broken apart on two tabs. The columns of
information are the same on both tabs.

Is this possible and if so how would I go about doing this?

Thanks



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