title: VBA Excel separate range of date in cells
body: <p>This is giving me a headache.. Im trying to do the following:</p>
  
  <p>This is the data I have, I have element's names and a start date and an end date.
  I want to have this data by day and not in range anymore (So I can upload it to a database I have which is by day).</p>
  
  <p>I dont know if I can do this without using VBA but I guess the quickes would be VBA.</p>
  
  <p>Current data:</p>
  
  <pre><code>╔═══════╦════════════╦════════════╗
  ║ name  ║ start date ║  end date  ║
  ╠═══════╬════════════╬════════════╣
  ║ foo1  ║ 25-11-2013 ║ 28-11-2013 ║
  ║ foo2  ║ 25-11-2013 ║ 28-11-2013 ║
  ║ foo3  ║ 25-11-2013 ║ 28-11-2013 ║
  ║ foo4  ║ 25-11-2013 ║ 28-11-2013 ║
  ║ foo5  ║ 25-11-2013 ║ 28-11-2013 ║
  ║ foo6  ║ 28-11-2013 ║ 28-11-2013 ║
  ║ foo7  ║ 28-11-2013 ║ 28-11-2013 ║
  ║ foo8  ║ 28-11-2013 ║ 28-11-2013 ║
  ║ foo9  ║ 28-11-2013 ║ 28-11-2013 ║
  ║ foo10 ║ 28-11-2013 ║ 28-11-2013 ║
  ║ foo11 ║ 29-11-2013 ║ 30-11-2013 ║
  ║ foo12 ║ 29-11-2013 ║ 30-11-2013 ║
  ║ foo13 ║ 29-11-2013 ║ 30-11-2013 ║
  ║ foo14 ║ 29-11-2013 ║ 30-11-2013 ║
  ║ foo15 ║ 29-11-2013 ║ 30-11-2013 ║
  ╚═══════╩════════════╩════════════╝
  </code></pre>
  
  <p>And I want to separate de names by day, to obtain this:</p>
  
  <pre><code>╔═══════╦════════════╗
  ║ name  ║    date    ║
  ╠═══════╬════════════╣
  ║ foo1  ║ 25-11-2013 ║
  ║ foo2  ║ 25-11-2013 ║
  ║ foo3  ║ 25-11-2013 ║
  ║ foo4  ║ 25-11-2013 ║
  ║ foo5  ║ 25-11-2013 ║
  ║ foo1  ║ 26-11-2013 ║
  ║ foo2  ║ 26-11-2013 ║
  ║ foo3  ║ 26-11-2013 ║
  ║ foo4  ║ 26-11-2013 ║
  ║ foo5  ║ 26-11-2013 ║
  ║ foo1  ║ 27-11-2013 ║
  ║ foo2  ║ 27-11-2013 ║
  ║ foo3  ║ 27-11-2013 ║
  ║ foo4  ║ 27-11-2013 ║
  ║ foo5  ║ 27-11-2013 ║
  ║ foo6  ║ 28-11-2013 ║
  ║ foo7  ║ 28-11-2013 ║
  ║ foo8  ║ 28-11-2013 ║
  ║ foo9  ║ 28-11-2013 ║
  ║ foo10 ║ 28-11-2013 ║
  ║ foo11 ║ 29-11-2013 ║
  ║ foo12 ║ 29-11-2013 ║
  ║ foo13 ║ 29-11-2013 ║
  ║ foo14 ║ 29-11-2013 ║
  ║ foo15 ║ 29-11-2013 ║
  ║ foo11 ║ 30-11-2013 ║
  ║ foo12 ║ 30-11-2013 ║
  ║ foo13 ║ 30-11-2013 ║
  ║ foo14 ║ 30-11-2013 ║
  ║ foo15 ║ 30-11-2013 ║
  ╚═══════╩════════════╝
  </code></pre>
  
  <p>Thank you in advance.</p>