Create an Inventory worksheet

I have a worksheet that I use column A for UPC numbers and Column B for the quantity of the inventory.

worksheet one (below)

854936003334 2
633422030326 1
021245619734 3
021245812098 3
727783900456 5

I need a second sheet to be created from the values on worksheet one with just the UPC numbers in column A, based on the count from sheet one's column B.

worksheet two (below)

854936003334
854936003334
633422030326
021245619734
021245619734
021245619734
021245812098
021245812098
021245812098
727783900456
727783900456
727783900456
727783900456
727783900456

I need to make sure this worksheet can have a leading 0 (zero), if the UPC number has one.

I hope this makes sense.
Thanks

In the attached 2 possibilities:
On Sheet1 a button to add a new sheet.
On Sheet1 (2), a little green table at cell D1 which you should right-click in and choose Refresh.

It's a good idea to attach a workbook - saves us time and us getting your setup wrong.

p45cal said:

In the attached 2 possibilities:
On Sheet1 a button to add a new sheet.
On Sheet1 (2), a little green table at cell D1 which you should right-click in and choose Refresh.

It's a good idea to attach a workbook - saves us time and us getting your setup wrong.

Click to expand...

Thanks, this is just what I need. I am curious what Sheet1 (2) is for? I have uploaded what I have added and formatted to this workbook.

James Empey said:

I am curious what Sheet1 (2) is for?

Click to expand...

Well…

p45cal said:

a little green table at cell D1 which you should right-click in and choose Refresh.

Click to expand...

If you try that, it produces a similar list using the data in the table at cell A1 (which is the same as your data on Sheet1)