title: Excel paste multiple times VBA
body: <p>I am hoping to find a macro which will allow me to paste a certain value X number of times into a separate worksheet.  Ideally, the number of "items" can easily be updated. </p>
  
  <p>For example sheet 1 looks like this: </p>
  
  <pre><code>Paste Value     Number of Pastes
  Item 1          3
  Item 2          1
  Item 3          5
  </code></pre>
  
  <p>On sheet 2, it would appear as</p>
  
  <pre><code>Item 1
  Item 1
  Item 1
  Item 2
  Item 3
  Item 3
  Item 3
  Item 3
  Item 3
  </code></pre>
  
  <p>I have found solutions to post on the same worksheet, but haven't been able to get it to paste to a separate worksheet. </p>
  
  <p>Thanks for your time. </p>