I want to print sales order forms to use when selling goods. I already have
the template created. I would like to print the template with a unique
contract number that will iterate by one each time the printer prints the
next copy of the sales form. i.e. If I print 30 copies of the template, each
one that comes out of the printer will have a unique contract number that
starts at 1 and ends at 30. Does anyone know how to do this?

One way would be to adapt the technique shown here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Use the Worksheet_BeforePrint() event instead of the Workbook_Open()
event.


In article <38645F50-C803-4619-BE5D-(E-Mail Removed)>,
Jbird <(E-Mail Removed)> wrote:

> I want to print sales order forms to use when selling goods. I already have
> the template created. I would like to print the template with a unique
> contract number that will iterate by one each time the printer prints the
> next copy of the sales form. i.e. If I print 30 copies of the template, each
> one that comes out of the printer will have a unique contract number that
> starts at 1 and ends at 30. Does anyone know how to do this?