![]() |
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 |
All times are GMT +1. The time now is 06:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com