I have a series of ID's residing on one sheet that I need to copy over to a second sheet. There are currently 37 ID's starting in C14 of Sheet1 through C50 but the number will vary. I need to paste each ID into Sheet2 starting in cell D7. Each ID needs to get pasted 6x, then I need to skip a row, then paste the next ID 6x and so forth until complete. Below is a sample of the end result I want to achieve through VBA.
<tbody>
</tbody>
D7 | ID01 |
D8 | ID01 |
D9 | ID01 |
D10 | ID01 |
D11 | ID01 |
D12 | ID01 |
D13 | |
D14 | ID02 |
D15 | ID02 |
D16 | ID02 |
D17 | ID02 |
D18 | ID02 |
D19 | ID02 |
D20 | |
D21 | ID03 |
D22 | ID03 |
... | ... |
<tbody>
</tbody>