Select specific Pivot-table item

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.

Please Login or Register  to view this content.

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.

Thanks everyone for time and effort in answering this question!

Hi just found my mistake. When I check for a specific name of a PivotItem I cannot use the .PivotItem.visible = True/False command but must check for the name, using an IF clause that checks the name:

Please Login or Register  to view this content.