| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot table, data from various spreadsheet
I have data in 3 separate spreadsheets (in the exact
format). I want to have a pivot table that consolidate data from these sheets. Is this possible? |
|
#2
|
|||
|
|||
|
Try Debra's page on:
Excel -- Pivot Tables -- Multiple Consolidation Ranges at: http://www.contextures.com/xlPivot08.html -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Derrick" wrote in message ... I have data in 3 separate spreadsheets (in the exact format). I want to have a pivot table that consolidate data from these sheets. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rearrange data columns in Pivot Table | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
| Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
Linear Mode
