Having a pivot table, I need to apply a filter with 1) a specific date and 2) data sets without a date.
I have tried the makro but it stops at " .PivotItems(i).Visible = False" in the first loop where i=1
Sub YesterdayBlank()
ActiveSheet.PivotTables("PivotTable2").ClearAllFilters
Dim...