| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace/select new fields in pivot table using a macro?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I replace/select new fields in pivot table using a macro?
Excel 2007 Pivot Table
Automated a generic Page Filter. http://www.mediafire.com/file/lmzuvz5mj1i/08_03_09.xlsm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Not able to select Calculated Fields for Pivot Tables | Excel Worksheet Functions | |||
| Select rows in pivot table with macro | Excel Discussion (Misc queries) | |||
| Since SP2, my pivot tables cannot select various fields | Excel Discussion (Misc queries) | |||
| Pivot Table Macro not inserting all data fields | Excel Discussion (Misc queries) | |||
Linear Mode
