Macro to add data once a Pivot Table has been refreshed

M

Mustang

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?
 
D

Dave Peterson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Macro to update pivot table data range 3
How to assign a macro to a pivot in Excel 2000 1
modified pivot table using a macro 2
Playing back a Pivot Table macros 2
Macro Debug on Pivot Table 5
macro creating new pivot table 2
pivot table variable range within a macro 4

Top