Printing sequentially numbered worksheets

[Jimmy]

I have a single worksheet that I use as a quality assurance form. Is there a
way to print multiple forms numbered sequentially?

 

[Bob I]

Several methods, pick the one that works for you

http://www.google.com/search?hl=en&q=excel+sequential+numbering

 

[Gord Dibben]

See Ron de Bruin's site for code.

Note the two sets of code. The second set will start numbering from where you
left off last time you printed a batch of sheets.

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

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

If need more help than that, post back and I'll walk you through.


Gord Dibben MS Excel MVP

 

[JE McGimpsey]

One way:

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