Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. Sub Test()
  2.  
  3. Dim pt As PivotTable
  4. Dim i As Integer
  5. Dim id As String
  6. Set pt = ThisWorkbook.Worksheets("sheet1").PivotTables("PivotTable1")
  7.  
  8. pt.PivotFields("ID").ClearAllFilters
  9. pt.PivotFields("ID").EnableMultiplePageItems = True
  10. For i = 1 To 10
  11. id = ThisWorkbook.Worksheets("sheet2").Range("A" & 57 + i).Value
  12. pt.PivotFields("ID").CurrentPage = id
  13. Next i
  14.  
  15. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement