VBA to select first item in a pivot filter then save copy as

[mgamal22]

i have a mobile usage table and i created a pivot table with a mobile number filter on the top to show the usage for each mobile number, what i am trying to do is to create a macro to start from the first number in the filter then save copy as in a folder with a cell reference in the same sheet then loop through all numbers in the filters till the end, but i am having troubles, if someone can help me out, Thanks alot

 

[SpillerBD]

Are you meaning to get results like using the "Show Report Filter Pages" ?

 

[mgamal22]

yes same as Show Report Filter Pages but i wanna show each item in the filter to be displayed in the same page and save copy of the sheet as a new sheet then do the same thing with the rest of the numbers in the filter

 

[SpillerBD]

"but i wanna show each item in the filter to be displayed in the same page"
I don't understand this part of your request.

I currently use the Show Filter Pages to create individual reports for about 80 cost centers. I then use another macro to export each of those Sheets to New Workbooks.