Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data- Pivot on multiple sheets
I have a pivot that looks like this:
Catalogs Data Data2 64 71 72 73 74 Circulation Forecast 10589 16381 11000 17381 11000 Budget 10589 16381 11000 17381 11000 The data for Forecast and Budget is in two separate tabs in my workbook. Can I create a single pivot table that pulls from two tabs? I was able to do the above by aggregating the data into a third tab, but this is not something I want to do every day. Thanks You!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data- Pivot on multiple sheets
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 tojo107 wrote: I have a pivot that looks like this: Catalogs Data Data2 64 71 72 73 74 Circulation Forecast 10589 16381 11000 17381 11000 Budget 10589 16381 11000 17381 11000 The data for Forecast and Budget is in two separate tabs in my workbook. Can I create a single pivot table that pulls from two tabs? I was able to do the above by aggregating the data into a third tab, but this is not something I want to do every day. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data- Pivot on multiple sheets
Great help -thank you very much...
"Debra Dalgleish" wrote: 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 tojo107 wrote: I have a pivot that looks like this: Catalogs Data Data2 64 71 72 73 74 Circulation Forecast 10589 16381 11000 17381 11000 Budget 10589 16381 11000 17381 11000 The data for Forecast and Budget is in two separate tabs in my workbook. Can I create a single pivot table that pulls from two tabs? I was able to do the above by aggregating the data into a third tab, but this is not something I want to do every day. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
Pivot shart referring to multiple sheets | Charts and Charting in Excel |