VBA to Repeat rows from its column

[irruzzz]

Master Jindon have helped me for http://www.excelforum.com/excel-prog...-products.html
And then I wanna print barcode sku with bartender application. It will print from xls database.

This is my database before :

2014-12-20_101001.png

the I want it be like this :
2014-12-20_101025.png

First, the row will copy itself allow his stock (column stock). If the stock is one, so the row just copy one, but if two, the row copy be two. But if the stock 0, it will be deleted.

Here is the sample spreedsheet bartender.xlsx

I dunno how to import vba script to excel. Anyone help me for creating the sample .xlsm spreedshet?

Many thanks

[jindon]

Try this

Please Login or Register  to view this content.

[irruzzz]

Try this

Please Login or Register  to view this content.

SOlved! thanks sir