How do I generate coupons template in Excel or Word based on item details and quantity (details below)?

Viewed 20

A master sheet with this data below

Item Name Item Code Item Qty
Item1 F01 50
Item2 F02 10

From the above, I would like to generate printable coupons - totally 60, that can be cut and distributed for an event. ( the items are food names).

Eg, one of them would have this information

"Item1 : F01-001" and "Item1 : F01-050" ( 50 of these) AND "Item2 : F02-001" and "Item2 : F01-010" ( 10 of these)

0 Answers
Related