How about using a little macro:
Option Explicit
Sub testme()
Dim iCtr As Long
For iCtr = 23 To 38 'whatever you want
With Worksheets("sheet1")
.Range("a1").Value = iCtr
.PrintOut preview:=True
End With
Next iCtr
End Sub
I printed from 23 to 38. Change it to what you need.
I printed Sheet1. Change that, too.
I put the number in A1. Use what you want.
and delete preview:=true when you're done testing.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Greeneyez2 wrote:
I have a Purchase Order template that I have to print, then renumber then
print again continuously. Is there a formula that make the template
automatically number sequentially even thought there is only one sheet?
--
Dave Peterson