Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Best way to append a range based on rows in a different range

I am trying to set up a sequence but struggles to find the best way to set up a loop for a part of this sequence.

This is what I am trying to do:

  1. Read a range in sheet 1.
  2. Read and copy a range in sheet2.
  3. Based on the number of rows in the range in sheet 1 I want to paste the range in sheet2 "n" number of times, each time under the previous one.

So if the range in sheet1 has 5 rows, the complete range in sheet 2 should be pasted 5 times, each in "first free row".

Will it be best to do it all in one loop, or to use a nested loop?

Login or Signup to post a comment