Auto Number for Form

[DHull]

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.

 

[David Biddulph]

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

 

[Eduardo]

Hi ,
See McGimpsey web

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

if this helps please click yes thanks

 

[Gord Dibben]

See Ron de Bruin's site for code.

http://www.rondebruin.nl/print.htm#same


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Do you actually want OP to open the workbook 100 times and print each time
with a new number?


Gord Dibben MS Excel MVP