| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table from diferent worksheets
How can I create a pivot table from data of 3 diferent worksheets ?
Thanks Daniel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table from diferent worksheets
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 Daniel wrote: How can I create a pivot table from data of 3 diferent worksheets ? Thanks Daniel -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table from diferent worksheets
Daniel,
You can use a ODBC UNION query with three parts to point to each of the three different worksheets (I assume they've got the same format). This makes the data appear as if it is coming from a single source so far as the pivot table is concerned. It's a wee bit messy to do but could probably be automated relatively easily with VBA. Ian On 27 Jul, 21:48, Daniel wrote: How can I create a pivot table from data of 3 diferent worksheets ? Thanks Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table using mutliple worksheets | Excel Discussion (Misc queries) | |||
| Pivot table using different worksheets/same workbook | Charts and Charting in Excel | |||
| Create pivot table from 2 worksheets | Excel Discussion (Misc queries) | |||
| Pivot Table with multiple worksheets | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple Worksheets | Excel Worksheet Functions | |||
Hybrid Mode
