K0st4din
Well-known Member
- Joined
- Feb 8, 2012
- Messages
- 501
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello, everyone.
after a long search on the Internet, I managed to find a table with which to make barcodes.
the table has one worksheet, I revised it to have two more worksheets and a total of 3.
The first will be the arrived commodity database.
in the second worksheet I have made models in which I choose which products I want to print (you will see when I attach the file).
On the third page, I will make the exact dimensions (frame) of the sheets themselves on which the barcodes will be printed.
What I can not handle is that I do not know how to do that if for the first product I have to populate 2 barcodes, add two if my second one needs 5 - add 5 barcodes and so on until the end .
In one sentence: As many pieces as I need, according to the product, so many barcodes to add.
It will have to be a macro, but I do not know how to do it.
I ask for your cooperation.
The font that makes the barcode itself is EAN13.
If you have questions, please ask, I will try to answer.
https://www.dropbox.com/s/3rf5q8c8nmswfn2/barcode ean13.xls?dl=0
after a long search on the Internet, I managed to find a table with which to make barcodes.
the table has one worksheet, I revised it to have two more worksheets and a total of 3.
The first will be the arrived commodity database.
in the second worksheet I have made models in which I choose which products I want to print (you will see when I attach the file).
On the third page, I will make the exact dimensions (frame) of the sheets themselves on which the barcodes will be printed.
What I can not handle is that I do not know how to do that if for the first product I have to populate 2 barcodes, add two if my second one needs 5 - add 5 barcodes and so on until the end .
In one sentence: As many pieces as I need, according to the product, so many barcodes to add.
It will have to be a macro, but I do not know how to do it.
I ask for your cooperation.
The font that makes the barcode itself is EAN13.
If you have questions, please ask, I will try to answer.
https://www.dropbox.com/s/3rf5q8c8nmswfn2/barcode ean13.xls?dl=0