Hello everyone i have a workbook with 3pivot tables
they all have a field called point of sales with 100 countries
i need to dublicate ths worksheet 100 times
and go through each one and just change the point of sales filter
if i just had 1 pivot table i would just use the:
Show Report Filter Pages
but that won't work now that i have 3 Pivot tables in 1 sheet.
any ideas?
thanks a lot!
they all have a field called point of sales with 100 countries
i need to dublicate ths worksheet 100 times
and go through each one and just change the point of sales filter
if i just had 1 pivot table i would just use the:
Show Report Filter Pages
but that won't work now that i have 3 Pivot tables in 1 sheet.
any ideas?
thanks a lot!