Printing Container Numbers 追蹤

0
Avatar
Legacy Poster

Hello, 

 

I have a spreadsheet that I am trying to link as a database to a label template. It is in the following format:

 

[Name] [Part#] [#ofcontainters]

Dog       ABC     2

Cat        DEF     3

 

If a given line lists X number of containers, I want to print that row X times and place a counter for the # out of X that printer

 

For example, the above sheet would be expanded to

 

[Name] [Part#] [#ofcontainters]

Dog       ABC     2

Dog       ABC     2

Cat        DEF     3

Cat        DEF     3

Cat        DEF     3 

 

and the labels printed would be:

 

Dog       ABC     1 of 2

Dog       ABC     2 of 2

Cat        DEF     1 of 3

Cat        DEF     2 of 3

Cat        DEF     3 of 3

 

Thanks for your help! 

1 意見

0
Avatar
Ian Cummings
版主
評論操作 永久連結

You need to data source the quantity to print for each record from the database field.  On the label you can have a serial number that resets to 1 for each record, and combine it with the quantity field for the X of Y text.

登入寫評論。