Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet-level event
I added a column next to a Pivot Table ("Comments"). When I refresh the
Pivot Table and it imports new data, the format of the Comments column becomes out-of-sync with that of the refreshed Pivot Table. No problem: I copy column D of the Pivot Table and Paste-Special/Formats to the Comments column (column E) to update that column's format to match the 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application level event help | Excel Discussion (Misc queries) | |||
workbook level name vs worksheet level name | Excel Programming | |||
Code for App level event (not firing) | Excel Programming | |||
Application level event handler broken in 2003SP1 ? | Excel Programming | |||
Monitoring application-level event problem | Excel Programming |