Sounds like a possible solution. Will give it a go and get back.
Thanks Herald for the link to the solution.
Murad

"Harald Staff" wrote:

Yes. See
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
for solutions.

HTH. best wishes Harald

"Murad Sheikh" skrev i melding
...
In excel; is there a way to automate the next invoice number.
This will help a lot. We manually generate invoices, but instead of
remembering the last invoice number; Is it possible to automate this
number;