| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Number for Form
Is there a way to auto number printed forms in Excel 2007? Example: mechanic
worksheet that is printed in batches of 100. I need consecutive numbers on each copy. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Number for Form
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
-- David Biddulph "DHull" wrote in message ... Is there a way to auto number printed forms in Excel 2007? Example: mechanic worksheet that is printed in batches of 100. I need consecutive numbers on each copy. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Number for Form
Hi ,
See McGimpsey web http://www.mcgimpsey.com/excel/udfs/sequentialnums.html if this helps please click yes thanks "DHull" wrote: Is there a way to auto number printed forms in Excel 2007? Example: mechanic worksheet that is printed in batches of 100. I need consecutive numbers on each copy. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Number for Form
See Ron de Bruin's site for code.
http://www.rondebruin.nl/print.htm#same Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 08:19:01 -0800, DHull wrote: Is there a way to auto number printed forms in Excel 2007? Example: mechanic worksheet that is printed in batches of 100. I need consecutive numbers on each copy. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Number for Form
Do you actually want OP to open the workbook 100 times and print each time
with a new number? Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 16:46:30 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- David Biddulph "DHull" wrote in message ... Is there a way to auto number printed forms in Excel 2007? Example: mechanic worksheet that is printed in batches of 100. I need consecutive numbers on each copy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| How do I auto shade every other line in a form already in use | New Users to Excel | |||
| auto numbering excell form | Excel Discussion (Misc queries) | |||
| how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
Linear Mode
