Try this
http://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Hi All,

I have problem on how can write the code for marco on Pivot table.
One master Pivot table and need to split different
PivotFields(Salesman) with new workbook, many many salesman, around
300. I don't want to manual create 300 pivot table and save as file.

Any one can help me, I know the code is very easy for someone (not for
me). Please give me a big hand.