How: Marco on Pivot Table to save as file up to 300 files

[beancurdjelly2003]

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.

 

[Ron de Bruin]

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

 

[beancurdjelly2003]

Try thishttp://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm







- $Bp}<(Ho0zMQJ8;z(B -

Hi Ron de Bruin,

I already amend the code and paste on my excel, still not work....
Maybe I don't understand...

Can you help me to look at my Master Pivot table, I already sent email
to you...

Thanks very much....so urgent, I need to solve the problem on
today.....If can't, I need to manual create 300 pivot table ~~~~

 

[beancurdjelly2003]

Hi Ron de Bruin,

I already amend the code and paste on my excel, still not work....
Maybe I don't understand...

Can you help me to look at my Master Pivot table, I already sent email
to you...

Thanks very much....so urgent, I need to solve the problem on
today.....If can't, I need to manual create 300 pivot table ~~~~ - $Bp,i6Ho0zMQJ8;z(B -

- $Bp}<(Ho0zMQJ8;z(B -

I want to split my Pivot Table to different PivotField and save as
file with Pivot table~~~~
Anyone can help me~~~

 

[beancurdjelly2003]

I want to split my Pivot Table to different PivotField and save as
file with Pivot table~~~~
Anyone can help me~~~- $Bp,i6Ho0zMQJ8;z(B -

- $Bp}<(Ho0zMQJ8;z(B -

Please~~~~~