| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
