How to Start

Input Data

Import Excel Data

Save Template

Output Word Excel

Barcode Format

Print Barcode

All Screen Shot

Label Designer

Export Barcode Image

Question:

I put 15 business cards on a page, a total of 1500 pieces (a total of 100 sheets)

Put numbers on the first sheet (sequence CCC-0001-BBB to CCC-1401-BBB),

Put numbers on the second sheet (sequence CCC-0002-BBB to CCC-1402-BBB),

Put numbers on the third sheet (sequence CCC-0003-BBB to CCC-1403-BBB),

Put numbers on the 99th sheet (sequence CCC-0099-BBB to CCC-1499-BBB),

Put numbers on the 100th sheet (sequence CCC-0100-BBB to CCC-1500-BBB)

The reason for this is that when we cut this stack of printed paper, each stack of business cards is arranged in a numerical sequence.

Answer:

I think our 'SN Builder' and 'Bulk data grid editor' can solve your problem.

To use this program, you need to enter multiple sets of formulas in an Excel file first, and then run the program to generate a set of serial numbers based on these formulas.

Note: This program only supports the old Excel 2003 format. If you are using a new version of Excel, please use Excel's 'File - Save As' function to convert the file to Excel 2003 format.

This program supports a variety of formulas and can generate serial numbers, enumeration values, etc., as shown below.

Barcode Value Print Quantity Title (optional)

CCC,001,005,1,B 1 Tittle-,001,005,1,

NNN,001,009,2,M 2 Tittle-,001,009,2,

CD-,10000,50000,4999, 3 Tittle-,10000,50000,5000,

ABC,[201,202,203,204],D 1 Tittle-,[201,202,203,205],D

ABC,[301,303,305],KM 1 Tittle-,[301,303,306],KM

,10000,50000,5000,-BC 1 Tittle-,10000,50000,5001,-BC

90001-,[AA,BB,CC,DD,EE], 1 Tittle-,[AA,BB,CC,DD,EE],

According to the requirements of the above example, you need to enter 100 lines of formulas to generate 100 sets of serial numbers.

Some sample formulas are listed below.

Barcode Value

CCC,001,015,1,BBB

CCC,011,015,1,BBB

CCC,021,025,1,BBB

CCC,031,035,1,BBB

CCC,041,045,1,BBB

It is a huge task to enter 100 lines of formulas manually, but you can use our 'Bulk data grid editor' to generate row formulas in batches.

The attached screenshot is the operation steps.

.

.

.

.