Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
Pivot comparison Geoff Excel Discussion (Misc queries) 0 April 1st 07 09:52 PM
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel westy Excel Worksheet Functions 5 March 10th 07 01:31 AM
Pivot Table row comparison revm2 Excel Discussion (Misc queries) 2 November 2nd 05 02:19 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM


All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"