# Thread: Create an Inventory worksheet

1. ## Create an Inventory worksheet

Register for a FREE account, and/
or Log in to avoid these ads!

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

2. 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.

3. Originally Posted by p45cal
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.
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.

4. Originally Posted by James Empey
I am curious what Sheet1 (2) is for?
Well…
Originally Posted by p45cal
a little green table at cell D1 which you should right-click in and choose Refresh.
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)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•