Copy/Paste a row x times

**Choppo** · 06-13-2013, 03:56 PM

Hi All,
New person here and I've searched the post expecting that someone else has asked this question and received an answer, but unfortunately I couldn't find anything.
How do I copy a row (columns A-Z) and paste it x times?
e.g. Copy row "A2-Z2" and paste it "N2" times where N2 can equal any qty.
this will help so much because Right now I'm doing it manually and I can have 300 rows and 1 row can need to be pasted 200 times.

Thank you in advance

**realniceguy5000** · 06-13-2013, 04:56 PM

Hi, Where do you want to paste the data?

Thanks, Mike

**Choppo** · 06-13-2013, 05:00 PM

It can be on another sheet. I had been copying and then inserting copied cells however many times. Seems cleaner to paste it on another sheet, then that way I still have the original info on sheet 1.
Thank you.

**realniceguy5000** · 06-13-2013, 05:35 PM

Hi, You can try this, not pretty but will work. It will copy sheet1 range A2:Z2 to sheet2 the 1st empty cell in col A however many times you want. If you want to copy each row on sheet 1 then you will need another loop such as script 2

I'm not sure I follow you completely on what you really want to do but you can advise if you need more help.

Thank You, Mike

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

**Choppo** · 06-13-2013, 06:02 PM

I've attached a sample of my data and the qty column list total number of rows I need pasted . Then goto to next row and so
on and so on till the last row is complete. Thank you very much.

**Leith Ross** · 06-14-2013, 02:31 AM

Hello Choppo,

The macro below has been added to the attached workbook. You can run the macro by calling the Macro Dialog by pressing the keys ALT+F8. The rows are copied to Sheet2 and any previous data is cleared before the new data is added.

Please Login or Register  to view this content.

**Choppo** · 06-14-2013, 10:20 AM

Wow! I just had my entire office at my cube watching this code run. You are freak'n awesome and I can not thank you and realniceguy5000 enough.
I appreciate the help you both provided me. Good Shot!