Dears,
I'm a VBA beginner and would like to get your support with the following.
I pool vendor transactions from the D365 Dynamic system, and it shows each vendor statement separately with the title of vendor number and name, I would like to know a way to do this task automatically
- I need to move "V-0001, vendor # 1 cells to appear before each voucher row and so on for the second table!
I'm a VBA beginner and would like to get your support with the following.
I pool vendor transactions from the D365 Dynamic system, and it shows each vendor statement separately with the title of vendor number and name, I would like to know a way to do this task automatically
- I need to move "V-0001, vendor # 1 cells to appear before each voucher row and so on for the second table!
V-0001 | Vendor # 1 | ||||
Voucher | Date | Description | Currency | Debit | Credit |
Voucher-1 | 01/05/2022 | Invoice-1 | USD | 1000 | |
Voucher-2 | 08/06/2022 | Payment-1 | USD | 1000 | |
Voucher-3 | 02/07/2022 | Invoice-2 | USD | 5000 | |
Voucher-4 | 05/08/2022 | Payment-2 | USD | 5000 | |
Voucher-5 | 30/09/2022 | Invoice-3 | USD | 2500 | |
Voucher-6 | 31/12/2022 | Payment-3 | USD | 2500 | |
V-0002 | Vendor # 2 | ||||
Voucher | Date | Description | Currency | Debit | Credit |
Voucher-7 | 08/05/2022 | Invoice-1 | USD | 1500 | |
Voucher-8 | 15/06/2022 | Payment-1 | USD | 1500 | |
Voucher-9 | 09/07/2022 | Invoice-2 | USD | 1890 | |
Voucher-10 | 12/08/2022 | Payment-2 | USD | 1890 |