title: Excel macro, to copy and paste a cell value based on another cell value?
body: <p>Hi I shall try to explain clearly what I need to be able to do, here goes:</p>
  
  <p>I have an Excel spread sheet 1 with postcodes in column <code>A</code> and a number in column <code>B</code>. I need to create a macro/formula so that it will see the number (i.e 3) and copy and paste the postcode that number of times into sheet 2 column a underneath each other. I need to do this for the next row down etc until it comes to a blank.</p>
  
  <p><strong>Sheet 1</strong></p>
  
  <pre><code>A       B
  DE43PP  3
  DE43PQ  8
  </code></pre>
  
  <p><strong>Sheet 2</strong></p>
  
  <pre><code>A       B
  DE43PP
  DE43PP
  DE43PP
  DE43PQ
  ...
  </code></pre>
  
  <p>Thanks</p>