Multiple worksheet Pivot Table
 

Hello,
I've got data that i'd like to put into a pivot table, but the data is over
65,000 rows...is there a way (other than access; b/c i don't know access) to
make a pivot table out of 2-5 worksheets within the same workbook?

Thanks!!!
-JC

Multiple worksheet Pivot Table
 

Hi

Choosing Data Pivottable, you see in the first screen appearing an option
to consolidate ranges. Choose the 3rd option in that screen and select the
different ranges in the following screens.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"JC" wrote:

Hello,
I've got data that i'd like to put into a pivot table, but the data is over
65,000 rows...is there a way (other than access; b/c i don't know access) to
make a pivot table out of 2-5 worksheets within the same workbook?

Thanks!!!
-JC