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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,215,754
Messages
6,126,679
Members
449,328
Latest member
easperhe29

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
Back
Top