Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Pivot Table PageArea Selection
My Current Pivot table (Named Pivottable1) on my sheet named MyPT has a Page
Area with Values (ALL, 1,2,3,4,5). I need to Change it from another sheet named Report!Range("b4").value - that would only contain the values, 1 to 5. When I enter into Cell B4, say 5 -- I need for my Pivottable1 (on MyPT sheet) to filter the PageArea selection to 5, and REFRESH the PT. How can I do this? Thanks in Advance for any assistance... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set selection of Pivot Table using VBA | Excel Programming | |||
Pivot table change selection | Excel Programming | |||
Pivot table change selection | Excel Programming | |||
Pivot Table - Multiple Pivot Field Selection | Excel Programming | |||
Pivot table selection | Excel Programming |