albertd
01-08-2020, 06:08 AM
Dear All,
I understand that this might be a long process, So I thought we can take it solve the intentions one by one and I would keep on editing the post :)
I have a data dump that I want to extract into a template and be printed out.
Here are my intentions:
1. 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.
Each template would be either limited daily OR maximum of 10 transactions as long as they are from the same credit source.
2. Values for the templates are:
3. Credit Source = Source + Source Name
4. Total = All values inside the voucher
5. Account = Item Code
6. Detail = Item Name
7. Unit Code = Unit Code
8. Value = Total Debit
9. As the datadump is extensive, is it possible to have ~10 sets of template in 1 Sheet and once they are printed out individually, they are deleted?
10. And Finally, to colour code for those that have been extracted to the template
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!25768
I understand that this might be a long process, So I thought we can take it solve the intentions one by one and I would keep on editing the post :)
I have a data dump that I want to extract into a template and be printed out.
Here are my intentions:
1. 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.
Each template would be either limited daily OR maximum of 10 transactions as long as they are from the same credit source.
2. Values for the templates are:
3. Credit Source = Source + Source Name
4. Total = All values inside the voucher
5. Account = Item Code
6. Detail = Item Name
7. Unit Code = Unit Code
8. Value = Total Debit
9. As the datadump is extensive, is it possible to have ~10 sets of template in 1 Sheet and once they are printed out individually, they are deleted?
10. And Finally, to colour code for those that have been extracted to the template
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!25768