How can I print the number of copies from an Excel spreadsheet?
TLDR*
Click the Print tab, select the Label Copies button and choose the relevant excel column you need to print.
*Too Long Didn't ReadOften your spreadsheet will include a column with a quantity of items received. This number might be exactly the number of labels you need to print. How do you setup Label LIVE to print the number of copies from this column?
Click the Print tab and notice how Label Copies
is a button. Click it and choose the spreadsheet column that represents the number of copies you need to print.
Remember, it doesn't need to be QTY
. There's nothing special about the name. It can be ITEMS_RECEIVED
or BOXES
or whatever exists in the spreadsheet.
Hint: To print every row's copies set Data Rows
to ALL.