title: VBA - Copy and Paste with increment
body: <p>Hi i need help on creating a VBA to copy range of cells repeatedly with one column having increments.</p>
  
  <p>Current data</p>
  
  <p><a href="https://i.stack.imgur.com/MPxpT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MPxpT.png" alt="enter image description here"></a></p>
  
  <p>Expected Output</p>
  
  <p><a href="https://i.stack.imgur.com/lx29Q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lx29Q.png" alt="enter image description here"></a></p>
  
  <p>I found a vba but will only copy the rows based on column C without increments on the date</p>
  
  <p><a href="https://stackoverflow.com/questions/25395454/excel-vba-automation-copy-row-x-number-of-times-based-on-cell-value">Excel VBA automation - copy row &quot;x&quot; number of times based on cell value</a></p>