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 on a single worksheet, or in a database,
and base the pivot table on that. You'll have more flexibility in
creating the pivot table
jo74 wrote:
Hi,
Sorry but I have gone through all help programs and cannot find how to make
a pivot table with multiple worksheets.Any help would be great.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html