Q
QT
hi all,
i need to print some label, but the label just a little bit difference from
each other.
Follwing is the template.
Box1:
Product Name: ABCxxx
Customer Name: ABCD company
QTY: 30
Cnt: 1 of 30
Box2:
Product Name: ABCxxx
Customer Name: ABCD company
QTY: 30
Cnt: 2 of 30
and box3 and so on are just change the Cnt: number of 30.
I don't want to make every label by copy and just change the Cnt value, it
really waste time for the quantity is very large.
So i want to know does excel can do with just one template and the value
will change automatically during printing the label.
If it can, how to do this? Thanks.
i need to print some label, but the label just a little bit difference from
each other.
Follwing is the template.
Box1:
Product Name: ABCxxx
Customer Name: ABCD company
QTY: 30
Cnt: 1 of 30
Box2:
Product Name: ABCxxx
Customer Name: ABCD company
QTY: 30
Cnt: 2 of 30
and box3 and so on are just change the Cnt: number of 30.
I don't want to make every label by copy and just change the Cnt value, it
really waste time for the quantity is very large.
So i want to know does excel can do with just one template and the value
will change automatically during printing the label.
If it can, how to do this? Thanks.