Hi All,
I have a weekly tasks where I have to create Pivot Tables for each Geographical Regions. I don't need to create the PT by VBA. Just need to flip filters (Tab Pivot Tables- Pivot Table name = "PivotTable2") based on a list(Regions). I would like to automate this by:
Select the Pivot Table Filters (Screen shot) based on a list on Regions on another sheets. Example - I'll like the VBA to look at my list of Regions, select the filters to show Southern, make a copy of the sheet of Southern, then continue with the next Region(Northern), make a copy the sheet for Northern, until the list exhausted - a pivot table is create for each region.
End result is: I have pivot table for each region on separate sheet
Thanks in advance for you help
Imran
I have a weekly tasks where I have to create Pivot Tables for each Geographical Regions. I don't need to create the PT by VBA. Just need to flip filters (Tab Pivot Tables- Pivot Table name = "PivotTable2") based on a list(Regions). I would like to automate this by:
Select the Pivot Table Filters (Screen shot) based on a list on Regions on another sheets. Example - I'll like the VBA to look at my list of Regions, select the filters to show Southern, make a copy of the sheet of Southern, then continue with the next Region(Northern), make a copy the sheet for Northern, until the list exhausted - a pivot table is create for each region.
End result is: I have pivot table for each region on separate sheet
Thanks in advance for you help
Imran