Excel

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

Guest

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?
 
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
 
Back
Top