Thank you Paul, i did find that link while reading thru other messages to
find an answer. I tried inserting the code but will not work for me. I'll try
to figure it out and let you know what i did wrong, maybe it will help
someone else too.

"Paul B" wrote:

Froggy68, have a look here,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Froggy68" wrote in message
...
I am trying to make an invoice that will automatically increase the
Invoice
number automatically everytime I open the file and is there a way to have
the
currant date update everytime the invoice file is opened to make a new
invoice. Is this possible? and if so How?