hi
that can get tricky. see this site.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

regards
FSt1

"Ed" wrote:

Have created an Invoice and am trying to generate a continous invoice number
every time I type a new name.