James Empey
New member
- Joined
- Dec 6, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 1
- Location
- San Luis Obispo, CA
- Excel Version(s)
- Microsoft® Excel® for Microsof
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
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
Last edited by a moderator: