Multiple worksheet Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top