title: VBA Macro to fill down column based on a pattern
body: <p>I have 6 columns: A, B, C, D, E, F. In Column A for example, I would like the following sequence:</p>
  
  <pre><code>A1:task1
  A2:task1
  A3:task1
  A4:task1
  A5:task2
  A6:task2
  A7:task2
  A8:task2
  A9:task2
  A10:task3
  A11:task3
  A12:task3
  A13:task3
  A14:task3
  </code></pre>
  
  <p>Where A stands for column A and 1, 3, 4....14 stands for row numbers</p>
  
  <p>As you can see from the above sequence, task 1 is repeated 4 times, followed by task 2 which is repeated 5 times, followed by task 3 which is also repeated 5 times. I would like to keep printing this sequence till row 200.</p>
  
  <p>I am relatively new to programming and would appreciate if someone could help me.</p>
  
  <p>Thank You.</p>