I would like to ask some help for some code to update a pivot table filter and record the result.
I have a file with 3 sheets:
1) Database sheet
2) Pivot table
3) Output
My pivot table is based on the full dataset held in the 'Database' tab. The output sheet contains a record for each "Company" I am working with.
The Pivot table has a filter applied by "Company", additionally there are several calculations next to the Pivot which will update as the filter does to provide one overall result in cell K1283
What I want to do is:
1) Develop code that will automatically update the Pivot table filter by removing the relevant "Company" and leaving all others - this record is also held in column A of the 'Output' tab. THe record filtered out should correspond to this column and the relevant record
2) Equate result incell K1283 in the 'Pivot' sheet and record it in the corresponding 'Output' sheet in column i of the "Company" record. This will record the relevant Pivot-driven output in the appropriate "Company" row
Any help would be greatly appreciated!!
I have a file with 3 sheets:
1) Database sheet
2) Pivot table
3) Output
My pivot table is based on the full dataset held in the 'Database' tab. The output sheet contains a record for each "Company" I am working with.
The Pivot table has a filter applied by "Company", additionally there are several calculations next to the Pivot which will update as the filter does to provide one overall result in cell K1283
What I want to do is:
1) Develop code that will automatically update the Pivot table filter by removing the relevant "Company" and leaving all others - this record is also held in column A of the 'Output' tab. THe record filtered out should correspond to this column and the relevant record
2) Equate result incell K1283 in the 'Pivot' sheet and record it in the corresponding 'Output' sheet in column i of the "Company" record. This will record the relevant Pivot-driven output in the appropriate "Company" row
Any help would be greatly appreciated!!
