Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
I have a workbook that contain 12 sheets each representing a months data.
Obviously each page is structured identically other than the month dates in column A. Is there anyway, other than combining the data onto one worksheet, that I can create a pivot table to display my data. What I would like is the Sheet or month to be the page. EA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
You can create a pivot table from 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 EA wrote: I have a workbook that contain 12 sheets each representing a months data. Obviously each page is structured identically other than the month dates in column A. Is there anyway, other than combining the data onto one worksheet, that I can create a pivot table to display my data. What I would like is the Sheet or month to be the page. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions |