Manipulate TEXT file based on Quantity
Manipulate TEXT file based on Quantity - I have a text file that I use as a database file to print labels. In this file one row might have 1500 as quantity. I need to then convert this single line to 3 lines as the product comes as 500 in a box so I need 3 labels (one for each box)
Some rows would need editing some would not.
I have a spreadsheet with the quantities that are in each product code - is there a way to compose a lookup and amend lines where required?
at lest for me this is confusing. Maybe you wanna clarify what you want to achieve.
An example is always welcome.