J Jimmy Feb 27, 2008 #1 I have a single worksheet that I use as a quality assurance form. Is there a way to print multiple forms numbered sequentially?
I have a single worksheet that I use as a quality assurance form. Is there a way to print multiple forms numbered sequentially?
B Bob I Feb 27, 2008 #2 Several methods, pick the one that works for you http://www.google.com/search?hl=en&q=excel+sequential+numbering
Several methods, pick the one that works for you http://www.google.com/search?hl=en&q=excel+sequential+numbering
G Gord Dibben Feb 27, 2008 #3 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
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
