I am attempting to create an automation that will complete the following steps:
- Copy details from the current row of tab (1) and append the current row to tab (3).
- Filter tab (2) based on a value from the current row in tab(1)
- Copy all available rows from tab (2) and append to tab (3)
- repeat these steps for all available rows
The automation I created works, utilizing excel for each row then append then an excel for each row within the first and another append, but it is extremely slow when completing the first excel for each. Is there another way I can structure the project to help performance? or are there any other performance solutions I could look at? A single trigger may have upwards of 400 rows for tab (1) and the current process takes about 30 seconds per row.