How do I replace/select new fields in pivot table using a macro?

S

snowdog

I have a pivot table that grabs data on a monthly basis and displays it by
global region (in columns) and by organizational function (in rows). I need
to export this data to a summary report. I need help writing a macro that
will replace/update the data reflected in this pivot table. For example, the
data in the pivot table is "Sum of June" and I need the macro to update it to
"Sum of July". I can do this manually by choosing the July data in the field
chooser list, but I need to get this process automated. Any help would be
great. Thanks.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
Macro to copy table of contents to a new doc 0
Pivot table 0
Pivot Table Counting Text Data 0
Pivot table overlaps another pivot table - how to find it 0
Excel 2007 pivot table using analysis services cube as data source 0

Top