Extract Multiple Rows into a Limited Template based on Multiple Criterias

[albertd]

Dear All,

I have a data dump that I want to extract into a template and be printed out.

Here are my intentions:

From the data dump (sample above), is it possible to automatically extract the appropriate value into the Template with a maximum of 10 rows for each set of Template. And then colour-code those that have been printed to the Template.
These are the Template (Payment Voucher) limitations:

a. Each template contains the data from only 1 (one) day

If in 1st January 2020 & 2nd January 2020, there are 5 transactions /day, there would have to be 2 Templates (1 for each day).

b. Each Template should only be from 1 Source

So if in 1st January 2020 & 2nd January 2020, there are 5 transactions/day from each Source A & B, there would be 4 Templates (1 for each source/day).

c. Each template could only contain 10 lines.

So if in 1st January 2020 & 2nd January 2020, there are 11 transactions/day from each Source A & B, there would be 8 Templates (2 for each source/day).


2. Values for the templates are:
- Credit Source = Source + Source Name
- Total = All values inside the voucher
- Account = Item Code
- Detail = Item Name
- Unit Code = Unit Code
- Value = Total Debit



Since I am new to VBA, I would have no issue with the inputs to their appropriate places and to colour code. But I am still learning about the loop function that I believe would be required for this?

Any help would be much appreciated!Sample.xlsmCapture.jpgFinal.jpg

---

(

Also posted here:
http://www.vbaexpress.com/forum/show...iple-Criterias
https://www.myonlinetraininghub.com/...iple-criterias
https://chandoo.org/forum/threads/ex...iterias.43376/
https://stackoverflow.com/questions/...iple-criterias
https://www.excelforum.com/excel-pro...criterias.html
https://superuser.com/questions/1515...iple-criterias