Registration date
April 11, 2019
Last seen
April 25, 2019
Contributions
7

copy x rows from a worksheet and paste x rows into another worksheet n times [Solved]

Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sheet 2 contains a column of data with 4000 rows. Hence, i am trying to insert and paste (A1:B50) from sheet 1 into each row in sheet 2. it should visually look like this: Sheet 1(A1:B50) ...

Excel | Latest reply : TrowaD
20 Answers