Excel invoice number

  • Thread starter Thread starter josh.morales
  • Start date Start date
J

josh.morales

Hello,

I need some assistance with a formula to create an incremental invoice
number. The invoice number has to increment every other page when
printed. I'm trying to print some carbon copy work orders/invoices.

Appreciate the help.

Thanks,
Josh
 
Josh
You will need a macro to do that. Something like the following. Change
the range to print to suit what you have. This macro increments A1 by 1 and
prints the range. As written it will do this 100 times. HTH Otto
Sub IncAndPrint()
Dim c As Long
For c = 1 To 100
Range("A1:G50").PrintOut
[A1].Value = [A1].Value + 1
Next c
End Sub
 
Back
Top