Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |