Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to add data once a Pivot Table has been refreshed
Hi,
I have a macro in place that uses the Advanced Filter funtion to pull out data for a particular month and then update an exisiting Pivot Table with the new months information. This works really well. However, we use the Page area to select client information. Once the client has been selected I would like a macro to run automatically to copy in certain information relevant to that client underneath the pivot table. My two problems are that I have no idea how to set the macro off once a page option has been selected or how to get my macro to copy data based on the current number of rows used. Any ideas gratefully received. Using Excel 2003 Many thanks Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to add data once a Pivot Table has been refreshed
There's a Worksheet_PivotTableUpdate event that you could tie into, but that may
fire too often for you. Have you thought of just plopping a button near the page field that the user could click after they changed the value? Mustang wrote: Hi, I have a macro in place that uses the Advanced Filter funtion to pull out data for a particular month and then update an exisiting Pivot Table with the new months information. This works really well. However, we use the Page area to select client information. Once the client has been selected I would like a macro to run automatically to copy in certain information relevant to that client underneath the pivot table. My two problems are that I have no idea how to set the macro off once a page option has been selected or how to get my macro to copy data based on the current number of rows used. Any ideas gratefully received. Using Excel 2003 Many thanks Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating chart from refreshed pivot table data | Charts and Charting in Excel | |||
Column width of Pivot Table data goes back to default when data refreshed | Excel Discussion (Misc queries) | |||
Pivot Table format changes when data is refreshed | Excel Discussion (Misc queries) | |||
Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |