Hi experts,
i am an newbie for the VBA and Power Query.. i will have to download reports from our old system and upload to new system everyday.. the downloaded file will have an pivot table output as below after cleaning data. what i need to be do is copy each output based on the kit no and Device to a separate CSV file. which is a duplicative task and the pivot table out put may go up 5000 rows..
each CSV files are names as KIT No & Device eg: AECWC00001 MCY
will any experts may help me to write an VBA/Macro to do this task ? copy each output group to separate CSV file in any folder ?
<colgroup><col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody>
</tbody>
this will be the output of the CSV file.. for eg output for SECWC000135 MCY
<colgroup><col style="mso-width-source:userset;mso-width-alt:3620;width:74pt" width="99"> <col style="mso-width-source:userset;mso-width-alt:2157; width:44pt" width="59" span="8"> <col style="mso-width-source:userset;mso-width-alt:2413;width:50pt" width="66"> </colgroup><tbody>
</tbody>
is this doable in power query ? or VBA ? either way i am more than happy to have a solution.
thanks in advance for your precious time and effort.
i am an newbie for the VBA and Power Query.. i will have to download reports from our old system and upload to new system everyday.. the downloaded file will have an pivot table output as below after cleaning data. what i need to be do is copy each output based on the kit no and Device to a separate CSV file. which is a duplicative task and the pivot table out put may go up 5000 rows..
each CSV files are names as KIT No & Device eg: AECWC00001 MCY
will any experts may help me to write an VBA/Macro to do this task ? copy each output group to separate CSV file in any folder ?
| KIT NO | Device | Sequence | Sum of Try |
| AECWC00001 | MCY | 9400003597193 | 78 |
| | |||
| SECWC00135 | MCY | 9400003262732 | 66 |
| 9400003262763 | 9 | ||
| 9400003262855 | 4 | ||
| 9400003262862 | 10 | ||
| 9400003262879 | 2 | ||
| 9400003262893 | 10 | ||
| 9400003370581 | 13 | ||
| | 9400003386384 | 3 | |
| 9400003391791 | 22 | ||
| 9400003816652 | 11 | ||
| | |||
| SECWC00136 | MCY | 9400003262732 | 3 |
| | 9400003262749 | 2 | |
| 9400003262763 | 25 | ||
| 9400003262770 | 12 | ||
| | 9400003262787 | 3 | |
| 9400003262794 | 14 | ||
| 9400003262855 | 13 | ||
| | 9400003262862 | 1 | |
| 9400003262893 | 12 | ||
| | 9400003370581 | 6 | |
| 9400003391791 | 9 | ||
| 9400003816652 | 3 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody>
</tbody>
this will be the output of the CSV file.. for eg output for SECWC000135 MCY
| Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | Header8 | Header9 | Header10 |
| 9400003262732 | 66 | ||||||||
| 9400003262763 | 9 | ||||||||
| 9400003262855 | 4 | ||||||||
| 9400003262862 | 10 | ||||||||
| 9400003262879 | 2 | ||||||||
| 9400003262893 | 10 | ||||||||
| 9400003370581 | 13 | ||||||||
| 9400003386384 | 3 | ||||||||
| 9400003391791 | 22 | ||||||||
| 9400003816652 | 11 | |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3620;width:74pt" width="99"> <col style="mso-width-source:userset;mso-width-alt:2157; width:44pt" width="59" span="8"> <col style="mso-width-source:userset;mso-width-alt:2413;width:50pt" width="66"> </colgroup><tbody>
</tbody>
is this doable in power query ? or VBA ? either way i am more than happy to have a solution.
thanks in advance for your precious time and effort.
