| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I iterate numbering when printing
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I iterate numbering when printing
One way would be to adapt the technique shown he
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Use the Worksheet_BeforePrint() event instead of the Workbook_Open() event. In article , Jbird 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| printing got numbering blocking | New Users to Excel | |||
| Iterate Circular Reference | Excel Discussion (Misc queries) | |||
| Iterate though all open spreadsheets | Excel Worksheet Functions | |||
| Printing/Page Numbering in Footer | Excel Discussion (Misc queries) | |||
| How do I fill down formulas so they iterate in intervals other th. | Excel Worksheet Functions | |||
Linear Mode
