Pivot Table
 

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!!

Pivot Table
 

See here for info on multiple consolidation ranges with pivot tables:
http://contextures.com/xlPivot08.html

Dave

On Apr 20, 10:28 am, Sue T wrote:
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!!

Pivot Table
 

Go to..
http://www.contextures.com/tiptech.html
And then click on Pivot Tables - Multiple Consolidation Ranges
And, yes, pivot tables do work a little differently with multiple
consolidation ranges. You can't do everything that you can with one source
range.

"Sue T" wrote:

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!!