My goal is to create a file for each Report Filter item with the report filter item as the filename in a Pivot Table. I need to copy the values and the format of the pivot table.
There are 2 ways i have tried
1) i can iterate through the slicer (Code included)
2) Use Excel functionality to...