title: Create a calendar table
body: <p>I want to create a calendar table for a full year starting lets say from 30/06/2014 to 30/06/2015. Also have 15 values of a variable that should be assigned to each one of those days in that year in a way:
  Column1=C1, Column2=C2</p>
  
  <pre><code>C1  C2
  0   30/06/2014
  0   01/07/2014
  0   02/07/2014
  .    .
  .    .
  0   30/06/2015
  3   30/06/2014
  3   01/07/2014
  3   02/07/2014
  .   .
  .   .
  3   30/06/2015
  123 30/06/2014
  123 01/07/2014
  123 02/07/2014
  .   .
  .   .
  123 30/06/2015
  </code></pre>
  
  <p>So ideally my table would look like this. 15 values times 366 days = 5490 rows.</p>
  
  <p>I have created an array with my values valuearry that could be useful for iterations.</p>
  
  <pre><code>StartDate = #6/30/2014#
  For i = 1 To 366
     j = 4
  
          Cells(i, 2) = StartDate
          StartDate = DateAdd("d", 1, StartDate)
          Cells(i, 1) = valuearray(j)
  
  Next i
  </code></pre>
  
  <p>I change manually the value of J since I couldn't find a proper way for automating this process. Any ideas of how I should arrange my loops and iterations to automate this process?</p>