| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
creating a pivot table w/ ranges from 2 worksheets
would someone please tell me how to create a pivot table from 2 worksheets
instead of combining all data in one. The problem is the source fields. I'd like to see my column headings but instead the source fields show up as Row, Column, Value. I'd like to know how to get my column headings to be my source fields so I can arrange them in a pivot table. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table: Mult Consolidation Ranges | Excel Discussion (Misc queries) | |||
| Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Can I combine two worksheets into one pivot table? | Excel Worksheet Functions | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
