Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table using data from multiple sheets
Is it possible to create a pivot table using data from multiple sheets within
the workbook? For example, pivot sheet 1 a1-a12 and sheet 2 c1-c5. If so, how do you do this? I keep coming up with errors. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table using data from multiple sheets
Look he
http://www.contextures.com/xlPivot08.html As an alternative, you may want to create a summary sheet, and build your pivot table off that: http://msdn.microsoft.com/en-us/library/cc837974.aspx HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "nabanco" wrote: Is it possible to create a pivot table using data from multiple sheets within the workbook? For example, pivot sheet 1 a1-a12 and sheet 2 c1-c5. If so, how do you do this? I keep coming up with errors. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table from multiple sheets? | Excel Discussion (Misc queries) | |||
Pivot Table with Multiple sheets | Excel Worksheet Functions | |||
Pivot Table Across Multiple Sheets of Data | Excel Discussion (Misc queries) | |||
Pivot table for multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table from multiple sheets | Excel Discussion (Misc queries) |