How do I create incremental numbers on an order form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to create an order form with incremental order numbers. When
I print a number of pages I would like each page to have a new number,
increased by 1, from the page before.
 
Unlike page numbers I need to print out 50 copies of the same page. Each
order form would have a different number; 001, 002, 003, etc.
 
Do you want the page numbers placed in a cell?

If yes, you could run a macro that prints the 50 copies:

Option Explicit
Sub testme01()
Dim iCtr As Long
With Worksheets("sheet1")
With .Range("a1")
.NumberFormat = "000"
For iCtr = 1 To 50
.Value = iCtr
.Parent.PrintOut preview:=True
Next iCtr
End With
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top