Possible to loop with a Pivot Table filter?

[Soran16]

I have a pivot table with a filter called "Location". Each quarter I have to filter for each "location" and paste the filtered pivot table flat into a separate workbook. I've looked online for hours and cannot find anything on creating a macro to filter a pivot table and paste the contents in another file. I'd greatly appreciate if anyone out there can assist.

[fshbet]

Hi Soran16,

jus try this code below.

Please Login or Register  to view this content.

Check my post for reference: http://www.excelforum.com/excel-prog...ml#post4075542