| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update pivot table report filter using cell value
Please point a VBA beginner in the right direction:
I want the code below to update the pivot table based on the cell value in "C5" of a worksheet named "Dates". Can this be done by amending the last line of recorded code below? Windows("VDN Daily.xlsm").Activate ActiveSheet.PivotTables("PivotTable1").PivotFields ( _ "[Record Date].[Date].[Date]").ClearAllFilters ActiveSheet.PivotTables("PivotTable1").PivotFields ( _ "[Record Date].[Date].[Date]").CurrentPageName = _ "[Record Date].[Date].&[2010-02-27T00:00:00]" Thanks for any help. David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VBA with Pivot Table Report Filter | Excel Programming | |||
| Pivot Table Report Filter Sorting | Excel Discussion (Misc queries) | |||
| how do i elmininate old data from Report filter on pivot table? | Excel Discussion (Misc queries) | |||
| Pivot table report filter problem | Excel Discussion (Misc queries) | |||
| Dimension Update and Pivot table report | Excel Discussion (Misc queries) | |||
Linear Mode
