Auto number for invoices

[Sl33py]

Good day.

I have a excel invoice template that I want to print for my invoice book.
I would like some help with a macro that will do a auto invoice number for me.
I would prefer not to have to open and close the file to generate the number but by the amount of pages I print.

I need to print 10 books with 50 invoice
Thanks

 

[Sl33py]

no excel fundies?

 

[PsyWulf]

Okay lets get this straight,you have a single page template,you want to automatically generate 500 pages with this number incremented by 1 on each and print

 

[Sl33py]

hi Sorry for the late reply, yes