Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables w/ comments comparison
Each month I generate a pivot table to reflect Year-To-Date expenses. I
include comments for purchases that are questionable, of interest, etc. Later I save copies of the pivots in an ordinary worksheet without the pivot table structure but with the same format. These are called expense reports. At the end of the quarter, I'd like to incorporate the comments from the prior three month's expense reports into 1 quarterly report. Thus, I'd like to put the comments in the right fields in the quarterly pivot table. Is there a way to combine the pivot tables into 1 with all the comments? Or is there a way to compare the pivot tables among each other to highlight the changes? Any advise on a better way to do this would be appreciated. Thanks in advance. -- Thanks, Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot comparison | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Table row comparison | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |