K
Karen
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.
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.