Hi All,

I posted the below thread to find out how to change a pivot table report filter based on a cell value, and found the solution I was looking for, however what I'm after now is a little more complex...

http://www.excelforum.com/excel-prog...worksheet.html

What I am looking to do is change a pivot table report filter to select multiple values based on a cell value in another worksheet. This is to total historical YTD by period. So as before I'm using cell D2 in sheet "Report" but this time it is PivotTable4 in sheet "T5".

This is what I am trying to achieve...

When 1 is selected in D2 Pivot Table filter selects 1.
When 2 is selected in D2 Pivot Table filter selects 1+2
When 3 is selected in D2 Pivot Table filter selects 1+2+3
and so on... there are 13 periods in total however we are only in period 4 at present so there is no data for periods 5-13.

Can anyone help?

Thanks again!