I have read many posts similar to this but can't get my vba code to work. Please help.
Sample data:
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>Based on the value in a5 - if it is greater than 1, I want it to copy and insert the same line x-1 times. For example in the second line, the value in a5 is 9, so i would like to see that exact line 8 addition times, or 9 times in total. For person3, where the value is 6, I would like to see that line 6 times in total, etc.
Thank you for the help!
Sample data:
A1 | A2 | A3 | A4 | A5 | A6A7 |
<tbody>
</tbody>
21609 | Gold | $10 | Person1 | 1 | $10 | Raffle1 |
21609 | Gold | $10 | Person2 | 9 | $90 | Raffle1 |
21609 | Gold | $10 | Person3 | 6 | $60 | Raffle1 |
|
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thank you for the help!