how to refer a pivot table filter to a cell and update it automatically?

[Ravikumar.subbiah]

Helo friends,


I have three Worksheets:


Data– this contains a table of data with three columns; Date, Name, Age

Pivot – this contains a pivot table of the data within the Data worksheet

Report_sheet – This contains a parameter which I would like to use to control the pivot table


What I would like to do is to change the date value in report_sheet (location cell C3), then run a macro, which would then filter all date values except the value with the date inserted in report_sheet (location cell C3)


So for example, if these are my dates within the ‘Dates’ column of my Pivot Table:


31/07/2010

07/08/2010

14/08/2010

21/08/2010

28/08/2010

04/09/2010


Then I set report_Sheet!c3 equals ‘04/09/2010’ then run the macro, only the line for ‘04/09/2010’ will be showing in the pivot table.


Please help me with a VBA code.


Thanks

Ravi

 

[srinidhi]

Check out this http://archive.msdn.microsoft.com/CellFilterPivot