Hi there. I have a pivot table that is updated every week. Now I would like to write a macro that selects the data only for the calendar week indicated in "A1" of Sheet1.
can anyone tell me why my concatenate code ("12 - " & Sheets("Sheet1").Range("A1") does not work? I do not get an error, but the macro also does not select any filter.![]()
Sheets("Sheet5").Select With ActiveSheet.PivotTables("PivotTable_Style-RM") .ClearAllFilters .PivotFields("calendar week").PivotItems(("12 - " & Sheets("Sheet1").Range("A1"))).Visible = True End With
Thanks everyone for time and effort in answering this question!
Bookmarks