pivot update range of values

Shiro26

Board Regular
Joined
Oct 2, 2015
Messages
82
Hello

I have a pivot that I call "pvt" and a field in which I paste my criteria and by clicking on a button it refreshes the pivot for the specific ID.
However, this is possible for the IDs one by one.
How could I modify the code in order to take more than one value, lets say in a named range in order to copy paste a set of ID?

Code:
Sub pvtRecRDupdate_click()
Dim wbk As Workbook
Dim wspvt As Worksheet
Dim SnapID As String, SnapPT1 As String
Set wbk = ThisWorkbook
Set wspvt = wbk.ActiveSheet
Application.ScreenUpdating = False
SnapID = wspvt.Cells(5, 1).Value
SnapPT1 = "pvt"
    With wspvt.PivotTables(SnapPT1).PivotFields("ID")
            .ClearAllFilters
            .PivotFilters.Add Type:=xlCaptionEquals, Value1:=SnapID
    End With
Application.ScreenUpdating = True
End Sub

Thank you in advance for your help

Kind Regards,

Shiro
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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,163,707
Messages
5,833,241
Members
430,199
Latest member
Petty queen

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