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

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.

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

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.

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

On 5$B7n(B4$BF|(B, $B2<8a(B6$B;~(B19$BJ,(B, "Ron de Bruin" wrote:
Try thishttp://www.rondebruin.nl/copy5.htm#workbook

--

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



wrote in ...
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.- $Bp,i6Ho0zMQJ8;z(B -

- $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 ~~~~ :(

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

On 5$B7n(B4$BF|(B, $B2<8a(B6$B;~(B55$BJ,(B, wrote:
On 5$B7n(B4$BF|(B, $B2<8a(B6$B;~(B19$BJ,(B, "Ron de Bruin" wrote:





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

--

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

wrote in ...
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.- $Bp,i6Ho0zMQJ8;z(B -

- $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 ~~~~ :(- $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~~~

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

On 5$B7n(B4$BF|(B, $B2<8a(B11$B;~(B01$BJ,(B, wrote:
On 5$B7n(B4$BF|(B, $B2<8a(B6$B;~(B55$BJ,(B, wrote:





On 5$B7n(B4$BF|(B, $B2<8a(B6$B;~(B19$BJ,(B, "Ron de Bruin" wrote:

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

--

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

wrote in ...
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.- $Bp,i6Ho0zMQJ8;z(B -

- $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 ~~~~ :(- $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~~~- $Bp,i6Ho0zMQJ8;z(B -

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

Please~~~~~