Here’s the thing. I need to copy each employee table existing in the raw file to a template which basically the same except it’s only for one employee. So it’s like whenever Employee Name appears in column A, I need to copy it from the row with employee name until the row which it appears again. For the below example, it’s A5:E12 and A14:E21. Number of rows is fixed, only the number of employees is changing.
I’m really not sure how to do this, I’m trying to look for some projects/questions here which the same with mine, but I can’t find any. Hopefully someone here have the same scenario as mine.
Since the number of rows if fixed you can probably use read range activity inside a loop (While loop with a flag). Each time compute the numbers (start row and end row).
For example for first iteration startrow = 5 , endrow = startwor + 6,
For next iteration startrow= endrow(of previous iteration)+1, endrow = startrow+6.