Multiple worksheet Pivot Table

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Excel Error while updating an external data source into a pivot table! 0
Pivot Table Data Source 1
Pivot Table with source spread across multiple worksheets 1
Consolidate Pivot Tables/Cache using Excel 2003 1
2nd Pivot Table on Worksheet Crahes Excel 1
Single Filter to change all Pivot Tables in a Workbook 8

Top