View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Karen is offline
external usenet poster
 
Posts: 447
Default 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