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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jude" wrote in message
...
I am using an Excel based invoice and I want to add a serial number that
will
automatically update each time I open a new invoice. Is there an easy way?
Thanks