You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example he

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

If possible, store your data in a database, and base the pivot table on
that. You'll have more flexibility in creating the pivot table.


PT Cruiser wrote:
I have data in a spreadsheet in excess of 65536 lines so I have the data on
more than one page in a workbook. How do I create a pivot table that will
use more than one page of data to create the pivot table? Is it possible?


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