J.E. McGimpsey shows how if you follow this link:

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

Hope this helps.

Pete

On Jul 1, 8:20 pm, George B wrote:
I have created a great invoice workbook for myself; I have everything linked
exactly as I want it. The only problem I have is I don't know how to make the
invoice number change after every save. Until I can do this, my workbook sits
idle. Can someone please help me? I greatrly appreciate any help I can get.
--
Have a wonderful day.