Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a single worksheet that I use as a quality assurance form. Is there a
way to print multiple forms numbered sequentially? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Several methods, pick the one that works for you
http://www.google.com/search?hl=en&q...tial+numbering Jimmy wrote: I have a single worksheet that I use as a quality assurance form. Is there a way to print multiple forms numbered sequentially? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 On Wed, 27 Feb 2008 13:02:03 -0800, Jimmy wrote: I have a single worksheet that I use as a quality assurance form. Is there a way to print multiple forms numbered sequentially? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html In article , Jimmy wrote: I have a single worksheet that I use as a quality assurance form. Is there a way to print multiple forms numbered sequentially? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sequentially nubered worksheets automatically? | Excel Worksheet Functions | |||
Can I compile data in sequentially numbered worksheets easier? | Excel Worksheet Functions | |||
How do I set up automatic sequentially numbering for worksheets? | Excel Worksheet Functions | |||
How do I number pages of worksheets sequentially? | Excel Discussion (Misc queries) | |||
how can i get excel to sequentially add numbers to new worksheets? | Excel Worksheet Functions |