Follow this link:

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

Hope this helps.

Pete

On Sep 25, 12:20 am, snowbugger
wrote:
I would like to know how I can have an Invoice number change from say 7200 to
7201 after the doc is saved so I don't have to do it manually every time I
write an invoice.