| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can I combine two worksheets into one pivot table?
I have two worksheets I want to build one pivot table from. There are 24
columns of data each. How do I do this? I have been trying multiple consolidation ranges and its not working. I don't get the headers to choose from when I try to create the table. I get Row, Column, value and page one as options. Thanks Todd |
|
#2
|
|||
|
|||
|
Hi
do both sheets have the same, indetical layout? -- Regards Frank Kabel Frankfurt, Germany Todd wrote: I have two worksheets I want to build one pivot table from. There are 24 columns of data each. How do I do this? I have been trying multiple consolidation ranges and its not working. I don't get the headers to choose from when I try to create the table. I get Row, Column, value and page one as options. Thanks Todd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table services | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Hybrid Mode
