duplicate a row with a macro
Hello all,
In excel, I want to write a macro that will do the following.
Lets say I have a sheet with 300 rows
I want to copy the first row, and paste this 180times in a separate worksheet.
Once its done this, move to the second row, and repeat the above, with it
being pasted under what i just did above, until its at the end of all the
rows.
Anyone got a scooby on how to do this!
Cheers
|