can a pivot table pull from multiple worksheets?
 

I have a workbook with 9 worksheets that I need to pull together for a
report. Can I use a pivot table for this? It would need to pull from all
those sheets and I don't know what the limits are.

Thanks,


Todd

can a pivot table pull from multiple worksheets?
 

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

Todd wrote:
I have a workbook with 9 worksheets that I need to pull together for a
report. Can I use a pivot table for this? It would need to pull from all
those sheets and I don't know what the limits are.


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