| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table to reference multiple sheets
Using multiple consolidation ranges creates a pivot table with several
limitations, as described he http://www.contextures.com/xlPivot08.html Perhaps you can move all the data to one sheet, or a database, as suggested in the article. massa wrote: I need to create a pivot table that references the data from 2 worksheets. I have tried the consolidation method but am confused when the field list does not carry over my column names. Can someone please advise? Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single Pivot Table 4 Multiple Sheets? | Excel Discussion (Misc queries) | |||
| Pivot table from multiple sheets - odd result | Excel Discussion (Misc queries) | |||
| Pivot table for multiple sheets | Excel Discussion (Misc queries) | |||
| Pivot Table from multiple sheets | Excel Discussion (Misc queries) | |||
| Pivot Table--How can I create from multiple sheets? | New Users to Excel | |||
Hybrid Mode
