| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ~~~~ :( |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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~~~ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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~~~~~ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Marco To Save Column A7 As A .txt File. | Excel Worksheet Functions | |||
| marco for a pivot table and expansion | Excel Programming | |||
| Pivot table marco problem! | Excel Programming | |||
| Marco: Pivot Table | Excel Programming | |||
| save file via Marco | Excel Programming | |||
Linear Mode
