Printing sequentially numbered worksheets

J

Jimmy

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print worksheet 2 on back of worksheet 1, etc.... 1
Auto update row numbers after inserting new row 4
worksheet cross reference 6
copy worksheet and automatically name 4
Windows 7 sequentially numbered file extensions 1
Auto re-numbering when a row is deleted 3
How do I create a form template that will be sequential numbered 1
Excel:Numbered Tickets Printing 4

Top