Copy and insert rows n number of times in Excel [Solved/Closed]

Posts
1
Registration date
Friday April 28, 2017
Last seen
April 28, 2017
-
I am trying to create a macro under Excel.

My data is as follows:

Col1 Col2 Col3 Col4 Col5 Col6 Col7
A1 1080 90 M 40 45 50
A2 999 90 M 25 30 35

I need output as follows

Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13
A1 1 1080 90 C M 0 0 40 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A1 2 1080 90 C M 0 0 45 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A1 3 1080 90 C M 0 0 50 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A1 4 1080 90 C M 0 0 40 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A1 5 1080 90 C M 0 0 45 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A1 6 1080 90 C M 0 0 50 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'

A2 1 999 90 C M 0 0 25 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A2 2 999 90 C M 0 0 30 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A2 3 999 90 C M 0 0 35 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A2 4 999 90 C M 0 0 25 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A2 5 999 90 C M 0 0 30 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'
A2 6 999 90 C M 0 0 35 UserID CURRENT_TIMESTAMP CURRENT_TIMESTAMP '9999-12-31 23:59:59.999999'


can anyone help me out with VBA code?
See more