Updating pivot filters through VDA

misderexcel

New Member
Joined
Jan 17, 2013
Messages
2
Hey

Please help this is driving me insane.

So I want to update a pivot by using a cell reference and the preceding numbers.
For example the pivot is showing teams workload over the preceding 6 weeks, and I want to update the weeks as a report is created through VBA and relies on this.
So i want to update the filter "reporting week" this pivot which resides on the sheet called "pivots" but I want to update this to show the week numbers: which the number taken from "data sheet" cell b8 and the preceeding 5 numbers.
IE "data sheet" cell b8 contains this weeks number (38) and I want the filter to be set at 38, 37, 36, 35, 34 and 33, but next week "data sheet" cell b8 will show 39 and I will want to show 39, 38, 37, 36, 35, & 34.
Any help gratefully received.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,119
Messages
5,835,500
Members
430,362
Latest member
ConnerJ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top