Jovannivk
07-01-2022, 08:46 AM
Hi everyone,
I'm running into a problem and can't convert it into VBA code.
In the attached appendix you will find a file with an analysis and output sheet. I would like to find something that adds data from a table per person to each other with the corresponding account code. In the output sheet I made an example of how I would like it to look.
So for each 'person' I have 3 values that I must have among each other with the corresponding account code next to it. So this will be three lines. In this way I want x3 lines under each other for each person. Then the next item comes in, the same story here.
You could immediately use 6 lines for 1 person. However, in my work file I work with hundreds of persons and dozens of account codes. So I want as few 'zero' lines as possible in my output. Some account rules can be completely zero.
I hope that's a bit clear. Thanks for the help!
Greetings,
Jovanni
I'm running into a problem and can't convert it into VBA code.
In the attached appendix you will find a file with an analysis and output sheet. I would like to find something that adds data from a table per person to each other with the corresponding account code. In the output sheet I made an example of how I would like it to look.
So for each 'person' I have 3 values that I must have among each other with the corresponding account code next to it. So this will be three lines. In this way I want x3 lines under each other for each person. Then the next item comes in, the same story here.
You could immediately use 6 lines for 1 person. However, in my work file I work with hundreds of persons and dozens of account codes. So I want as few 'zero' lines as possible in my output. Some account rules can be completely zero.
I hope that's a bit clear. Thanks for the help!
Greetings,
Jovanni