data numbering in Excel for sequential numbering depth

kbr428

New Member
Joined
Dec 19, 2005
Messages
1
How do I create a numbering system (database) in excel to use as a mailmerge with an addressing laser?

I want to be able to number invoices 2 or 4 up on an 11x17 NCR, being either 2-3-4 part caronless forms depth.
Then use this information as a data source for my addressing laser, which only accepts xls or csv data formats.

Ex: I have a 3 part NCR (no carbon required) form, which the invoice layout is 5-1/2x8-1/2 size, which fits 2-up on a 8-1/2x11 form or 4-up on a 11x17 form.
I want to be able to change the starting, whether 1 or 10000 and change the ending number, 100-5000 sequential numbered, with the depth of 3 times each number per form.

Thanks,
KBR
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,118,234
Messages
5,571,045
Members
412,359
Latest member
misstoffeepenny
Top