This is two separate projects in 1 request. I have two different inventory spreadsheets that I would like to be able to quickly create box labels prior to shipping.
Spreadsheet #1 comes from a manufacturer. It contains a box number and the items in the box. These boxes sometimes contain anywhere from 10 to 100 serialized items. I need to print (on a 4x6 label) the box number (once) and all the serial numbers contained in that box. (these serial numbers can be anywhere from 7 to 22 digits long.
Spreadsheet #2 I create. It contains a box number, the part number, description, and quantity of the items in the box prior to shipping. I need to print (on a 4x6 label) the box number and total number of boxes (i.e. box 7 of 15), the part number, the description, and the quantity. The items going in the box is always dynamic and is rarely the same things in the same box.
I will provide examples of both spreadsheets and both outputs that I'm looking for.
Please let me know if you have any questions.