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?

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