In your first posting, two people suggested:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

JulieD said

Hi

if you'ld like to email me direct (julied_ng at hcts dot net dot au) i
have a sample invoicing workbook that you can have a look at and maybe get
some ideas from or customise for your own purposes.

Cheers
JulieD

--
Regards,
Tom Ogilvy



"Toinett" wrote in message
...
I would like the macro to increase the invoice number by one so it is
ready
to go for the next order.