Automatically Generate Lines

I am trying to generate a delivery form.
Earlier in the sheet I have listed the descriprion and the QTY required so for example one Cell Would say "Product A" and the Next Cell would be "20".

On the delivery note I want to have the "Product A" listed 20 times as I have to put a barcode next to each of them.

Is it possible to duplicate the description by the Qty Number. If so what is the command to do this, I have looked through the forums but cannot find anything remotly close that explains how to do this!

Thank you in advance!

You probably need to post your spreadsheet(s) to get a complete solution, but if you can adjust a little VBA code see the attached:

You can use a Worksheet Change Event to generate these duplicate entries the listed number of times.

The code assumes you want the duplicate data directly below the existing data. (you can direct this to any other cell) And it is working off the Change Event of a quantity entry in Column B.