Printing Sequential Barcodes without having to create the sequence in Excel

[Worthawiggles]

Hi, I need some help please. We have made a move from barcode printed labels added to a pallet on an A4 sheet to an A4 sheet printed with an integrated barcode. Saves time. The issue is that each bar code has a suffix that indicates the pallet number and is incorporated into the bar code, e.g. *4018003/2* and then the next would be *4018003/3* I am looking to be able to put in the 7 digit number and the number of pallets inot a template in excel and and Excel will generate the bar code through an add in and auto add the suffix sequential number, print these to the number of pallets sheets requested. At the moment I am having to create each par code in a list and print individually. How do I achieve a more streamlined version. I have searched google and cannot find an answer, hence joining this forum. Thanks in Advance, James.

 

[Georgiboy]

Not sure i understand the printing part, the below will generate the barcodes though, might be a good starting point.

Book1.xlsm
	A	B	C	D
1	Barcode	Number of barcodes
2	4018003	10		*4018003/1*
3	4018004	5		*4018003/2*
4	4018005	7		*4018003/3*
5				*4018003/4*
6				*4018003/5*
7				*4018003/6*
8				*4018003/7*
9				*4018003/8*
10				*4018003/9*
11				*4018003/10*
12				*4018004/1*
13				*4018004/2*
14				*4018004/3*
15				*4018004/4*
16				*4018004/5*
17				*4018005/1*
18				*4018005/2*
19				*4018005/3*
20				*4018005/4*
21				*4018005/5*
22				*4018005/6*
23				*4018005/7*
Sheet2

Cell Formulas
Range	Formula
D2:D23	D2	=LET(n,B2:B4,s,SEQUENCE(,MAX(n)),"*"&TOCOL(IF(s<=n,A2:A4&"/"&s,#N/A),3)&"*")
Dynamic array formulas.

 

[Worthawiggles]

Not sure i understand the printing part, the below will generate the barcodes though, might be a good starting point.

Book1.xlsm
	A	B	C	D
1	Barcode	Number of barcodes
2	4018003	10		*4018003/1*
3	4018004	5		*4018003/2*
4	4018005	7		*4018003/3*
5				*4018003/4*
6				*4018003/5*
7				*4018003/6*
8				*4018003/7*
9				*4018003/8*
10				*4018003/9*
11				*4018003/10*
12				*4018004/1*
13				*4018004/2*
14				*4018004/3*
15				*4018004/4*
16				*4018004/5*
17				*4018005/1*
18				*4018005/2*
19				*4018005/3*
20				*4018005/4*
21				*4018005/5*
22				*4018005/6*
23				*4018005/7*
Sheet2

Cell Formulas
Range	Formula
D2:D23	D2	=LET(n,B2:B4,s,SEQUENCE(,MAX(n)),"*"&TOCOL(IF(s<=n,A2:A4&"/"&s,#N/A),3)&"*")
Dynamic array formulas.

Hi Thanks for the response. I can create something similar in excel, however, not as clean, technically advanced or as efficient as your method shown. I am looking to create the sequence of a 7 digit number manually entered along with the number of pallets (and hence prints and suffixes) required and have Excel print these automatically from a print request as a bar code embedded into an A4 sheet. Once the 7 digit number is entered and matched with the number of suffixes to print excel will then print these.