| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot
hi, how can i build a pivot for data in two or more sheets in the same
workbook? if i cant make a pivot, what are the possible alternatives to consolidate the data. thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot
You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want. There's more information he http://www.contextures.com/xlPivot08.html Perhaps you could store all your data on one sheet, or in a database, and create the pivot table from that. Malik wrote: hi, how can i build a pivot for data in two or more sheets in the same workbook? if i cant make a pivot, what are the possible alternatives to consolidate the data. thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
