Macro to copy row and multiply by n times

**mlocy** · 03-21-2013, 10:06 AM

Hi,

I am trying to copy each row and insert the same number of rows based on column B. So Columns A to G will be copied and be mulitplied by the value in column

E.g Row 2 will be copied and insert 19 new lines underneath creating 20 rows because column B's value is 20
E.g Row 2 will be copied and insert 14 new lines underneath creating 15 rows because column B's value is 15

20TH MARCH 2013.xls

**AB33** · 03-21-2013, 10:22 AM

Not sure if you want to fill in the blank rows in column A. Output in sheet2

**mlocy** · 03-21-2013, 10:40 AM

You my friend are a genius, made my life so much easier!!

**AB33** · 03-21-2013, 10:55 AM

Mlocky,
I have added one line to adjust the columns. Please see attached above.
If you are happy with the solution provided, please close this thread.
Go in to the top right hand of this page, choose "Thread Tools", then solved from the drop down menu