Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print consecutivly numbered copies of the same form?
We have a form that we use on a regular basis that is printed blank for
employees to fill out daily. Each form must be consecutivly numbered to provide a unique ID for it. Is there a way to print out around 100 of these at a time without manually changing the number on each page? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print consecutivly numbered copies of the same form?
Try this macro from Ron de Bruin.
This example will print ? copies of the same sheet (It use a Input box to ask you how many) It will copy the page number in cell A1or in the Header or Footer. Sub PrintCopies_ActiveSheet() Dim CopiesCount As Long Dim CopieNumber As Long CopiesCount = Application.InputBox("How many Copies do you want", Type:=1) For CopieNumber = 1 To CopiesCount With ActiveSheet 'number in cell A1 .Range("a1").Value = CopieNumber & " of " & CopiesCount 'number in the footer '.PageSetup.LeftFooter = CopieNumber & " of " & CopiesCount 'Print the sheet .PrintOut End With Next CopieNumber End Sub Gord Dibben MS Excel MVP On Wed, 28 Jun 2006 10:29:02 -0700, dsmith@shealylab wrote: We have a form that we use on a regular basis that is printed blank for employees to fill out daily. Each form must be consecutivly numbered to provide a unique ID for it. Is there a way to print out around 100 of these at a time without manually changing the number on each page? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print a data entry form without the spreadsheet as a background? | Excel Discussion (Misc queries) | |||
How do I in excel print consecutive numbers from one form? | Excel Discussion (Misc queries) | |||
print page seprator for mutiple copies in excel is not working | Excel Discussion (Misc queries) | |||
Print scrollable user form. | Excel Discussion (Misc queries) | |||
print multiple copies of the same page with sequential numbers | Excel Discussion (Misc queries) |