Excel invoice number

[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

 

[Otto Moehrbach]

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