title: Excel VBA automation - copy row "x" number of times based on cell value
body: <p>I'm attempting to automate Excel in a way that will save me countless hours of tedious data entry.  Here's my problem.</p>
  
  <p>We need to print barcodes for all of our inventory, which includes 4,000 variants each with a specific quantity.</p>
  
  <p>Shopify is our e-commerce platform and they do not support customized exports; however, can export a CSV of all variants, which includes an inventory count column.</p>
  
  <p>We use Dymo for our barcode printing hardware/software.  Dymo will only print one label per row (it ignores the quantity column).</p>
  
  <p>Is there a way to automate excel to duplicate the row "x" number of times based on the value in the inventory column?</p>
  
  <p>Here's a sample of the data:</p>
  
  <p><a href="https://www.evernote.com/shard/s187/sh/b0d5b92a-c5f6-469c-92fb-3d4e03d97544/d176d3448ba0cafbf3d61506402d9e8b/res/254447d2-486d-454f-8871-a0962f03253d/skitch.png" rel="nofollow">https://www.evernote.com/shard/s187/sh/b0d5b92a-c5f6-469c-92fb-3d4e03d97544/d176d3448ba0cafbf3d61506402d9e8b/res/254447d2-486d-454f-8871-a0962f03253d/skitch.png</a></p>
  
  <ul>
  <li>If Column N = 0, ignore and move to next row</li>
  <li>If Column N > 1, copy current row, "N" number of times (to a separate sheet)</li>
  </ul>
  
  <p>I tried to find someone who had done something similar so that I could modify the code, but after an hour of searching I'm still right where I started.  Thank you in advance for the help!</p>