Multiple worksheet Pivot Table

[JC]

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

 

[Wigi]

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.