I need a small and simple program where the data is taken from a table and generates a label based on the data there. For example, I put in the following data:
Date: April 1
Item Code: AP101
Item Description: Apples (vlookup value)
Quantity per Box: 100 (vlookup value)
Required Quantity: 1,000pcs
This should generate 10 labels(3 copies on an A4 paper) with the details above and numbering from AP101-001, AP101-002, AP101-003, etc until AP101-010. If I put in 10,000pcs, then I get 100 labels up to AP101-100.