Pivot Table

G

Guest

Hello - I have two very large worksheets with the same type of data and same
column headings in both. I want to create one pivot table using both of the
worksheets.. I have gone into the wizard and chosen multiple consolidation
ranges and when it comes up it only gives me column, row, and data for the
choices for the layout. I use pivot tables all the time and have created
many, but this has me stumped. Can anyone give me a step by step instruction
to do this.
Thank You for Your Help!!
 

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 multiple consolidation ranges 3
One pivot table for multiple worksheets/tabs 2
how do I create Excel pivot table with over 65,535 lines of data? 1
Consolidated pivot tables 1
Pivot Table - include multiple worksheets with different ranges. 1
Combine multiple ranges into one worksheet 1
Access #Error & Excel Pivot 0
Pivot Table Data Source 1

Top