Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Formatting to Changed Pivot Table
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate pivot table selection | Excel Discussion (Misc queries) | |||
Automate Pivot Table to only 1 Item | Excel Discussion (Misc queries) | |||
Automate Pivot Table Report | Excel Programming | |||
Automate Pivot Table Drill down | Excel Worksheet Functions | |||
Automate Graph of Pivot table | Excel Programming |