Loop through Pivot Page Fields and paste summary into different new workbooks.

[shiva_raj]

HI,


Pls go through the attachment. i wrote a VBA code to create PIVOT. Now i want to copy each pivot summary (by filtering "PageField" (Manager Name ) ) into each new workbook. New workbook name should be as "PageField" item.


Thank you in advance.


Regards
Shiva

[shiva_raj]

I tried myself and succeeded.