Labels Sheet
...
Header | Barcode | Field 1 - Order Date | Field 2 - Order No/Revision/LineNo | Customer Name | Order Ref | Product | Location | Dimensions | Print Qty | End Format |
|---|---|---|---|---|---|---|---|---|---|---|
=IF(OR(Data!$AV11="",Data!$AW11>999),"","^XA^LH0,0^PRB,D^MD20^JMA^FS") | =IF(A11<>"","^BY2,2.7,13^FO506,20^B2N,132,Y,N,N^SN"&BarcodeValue(Data!BC$5,Data!BD$5,Data!AW11,1,0)&",N,Y^FS","") | =IF(A11<>"","^FO20,20^A0N,28,37^CI13^FD"&TEXT(Data!AY$5,"d/m/yyyy")&"^FS","") | =IF(A11<>"","^FO220,20^A0N,41,48^CI13^FD"&Data!$BC$5&Data!$BD$5&"/"&RIGHT("000"&Data!AW11,3)&"^FS","") | =IF(A11<>"","^FO20,55^A0N,30,30^CI13^FD"&Data!$BF$5&"^FS","") | =IF(A11<>"","^FO20,95^A0N,30,30^CI13^FD"&Data!AX$5&"^FS","") | =IF(A11<>"","^FO20,135^A0N,30,30^CI13^FD"&Data!BE11&"^FS","") | =IF(A11<>"","^FO20,175^A0N,30,30^CI13^FD"&Data!AY11&"^FS","") | =IF(A11<>"","^FO300,175^A0N,30,30^CI13^FD"&"W:"&Data!BA11&" H:"&Data!BB11,"") | =IF(A11<>"","^PQ"&Data!$F$10&",0,"&Data!$F$10&",Y","") | =IF(A11<>"","^XZ","") |
...
To print the labels multiple times, set the number of copies required in the data settings (as per the example below to print 3 copies) and configure the Print Qty cell to
=IF(A11<>"","^PQ1,0,"&Data!$F$14&",Y","")
...
For more information about labels, we have a few links that can assist your setup
...