Hello,
If I download a list from exact it looks like below:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Ideally I would like to move the account names to the column next to the numbers, until the next subtotal, so that I can build a proper pivot table with the option to filter on account.
I'm sure it can be done, but I lack the VBA experience. Would be great if anyone out there could help me.
Thank you,
Jos
If I download a list from exact it looks like below:
Subtotaal | ||||
Akro Netherlands Inc. - 1682 | ||||
19.0263 | 22-08-2019 | 19603880 | 60 - Inkoopboek | 85 Plaatje zwart MDF |
19.0282 | 11-09-2019 | 19604279 | 60 - Inkoopboek | Opgebouwde wand + blisterhaken display |
19.0305 | 27-09-2019 | 19604577 | 60 - Inkoopboek | Materiaal Hema |
Subtotaal | ||||
AMG Bouw BV - 1815 | ||||
2019/00311 | 27-09-2019 | 19604578 | 60 - Inkoopboek | Pelicaen Vitrine |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Ideally I would like to move the account names to the column next to the numbers, until the next subtotal, so that I can build a proper pivot table with the option to filter on account.
I'm sure it can be done, but I lack the VBA experience. Would be great if anyone out there could help me.
Thank you,
Jos