multi sheet pivot tables

Can you create a single pivot table that takes it information from multiple
worksheets within one excel document?

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 here:

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

If you can combine the data in your own database, then use that as the
source, you'll have more flexibility in creating the pivot table.


bamf wrote:
> Can you create a single pivot table that takes it information from multiple
> worksheets within one excel document?


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