Hi everyone(:
I'm having trouble creating pivot tables using macros.
First i tried recording it then running the exact same thing. It worked fine the first time but a week later when i tried it again the pivot table failed me. As i am using raw data as the data source, hence the number of rows changes everyday and therefore the datasource for the pivot table code cannot be fixed.
How do i do this?...
2 results in 0.0030 seconds.
-
Create pivot table using macros
-
Updating Pivot Table Page Fields based on another page field
I have been working with VBA for less than a year, but mostly in Access. I have come accross an issue in Excel that I want to solve programatically .
I have several pivot tables on one work sheet that feed several pivot charts.
I am looking for code that will update each pivot table based on the page I select from the first pivot table on that worksheet.
Basically, once I update the first pivot table,...
