Hi, i am using the below code to copy the data from each row and paste it below on same sheet by the times mentioned in column P (multiplier can be different for each row) .
Dim i As Long
For i = Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1
Rows(i).Copy
Rows(i).Resize(Range("P" & i)).Insert
Next i
Now i am not the best in coding so require some help to customize it.
The above code works fantastics but the only problem is when the multiplier is 0, then the code breaks. I would like to skip the row where the muliplier is 0 and move to the next one. can someone help me edit the above please.
thanks in advance.
cheers
Dim i As Long
For i = Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1
Rows(i).Copy
Rows(i).Resize(Range("P" & i)).Insert
Next i
Now i am not the best in coding so require some help to customize it.
The above code works fantastics but the only problem is when the multiplier is 0, then the code breaks. I would like to skip the row where the muliplier is 0 and move to the next one. can someone help me edit the above please.
thanks in advance.
cheers