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:
- Read a range in sheet 1.
- Read and copy a range in sheet2.
- 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?