Macro prints barcodes according to the number of products

K0st4din

Well-known Member
Joined
Feb 8, 2012
Messages
501
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. 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
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
A little addition.
If it is very difficult to get information from a worksheet "Print product", something / way of taking the information from the worksheet "BASE"
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top