Usng Vba can i get two pivot tables to show the same data?

[tonywatsonhelp]

Hi Everyone,

I have two pivot tables
the first is "PivotTable2"
the other is "PivotTable3"

Now "PivotTable2" gives me result for salespeople according to a number of slicers i use

one of the columns is called "Sales Week"
And has a list o weeks like this
2020-W01
2020-W02
2020-W07
etc.

now "PivotTable3" has the same header "Sales Week"
but list different weeks because the critiors are different, so it show more weeks

like this:
2020-W01
2020-W02
2020-W03
2020-W04
2020-W05
2020-W07
etc.

now i know the pivot tales have filters and i can manually filter to only show in "PivotTable3" ,"Sales Week"
the same weeks as "PivotTable2" ,"Sales Week"

but i can't do it with a macro which i need?

now if its easier i can create a list of the weeks i want to show in Column A so instead of going to pivot table 2 you just filter "PivotTable3" ,"Sales Week" to show only the weeks in column A but i still need help on how to do this

any ideas or help would be greatly appreciated

Thank you

Tony