PC Review


Reply
Thread Tools Rate Thread

Automate Formatting to Changed Pivot Table

 
 
=?Utf-8?B?RXhjZWxsZXI=?=
Guest
Posts: n/a
 
      27th Sep 2007
I added a column next to a Pivot Table ("Comments"). When I change the Pivot
data the format of the Comments column becomes out-of-sync with that of the
(new) Pivot Table. No problem: I copy column D of the Pivot Table and
Paste-Special/Formats to the Comments column (column E) to make it match the
format of the new Pivot Table

How can I automate this, so when the Pivot Table changes the format of
column D is automatically copied and pasted to column E?

Thanks.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I automate creating the pivot table =?Utf-8?B?TUg=?= Microsoft Access Macros 0 5th Nov 2007 07:14 PM
Automate Pivot Table to only 1 Item =?Utf-8?B?U3RldmU=?= Microsoft Excel Misc 0 25th Sep 2007 08:58 PM
Automate Pivot Table Report Excel_Newbie Microsoft Excel Programming 1 18th Nov 2005 03:22 AM
Pivot Table border formatting and pivot chart formatting cailotto@sbcglobal.net Microsoft Excel Misc 0 22nd Jul 2005 02:22 PM
Automate Graph of Pivot table Bruce Stemplewski Microsoft Excel Programming 0 28th Jul 2003 04:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:58 AM.