How do I generate a new invoice number when creating new invoice?

[Guest]

hello. i have an invoice template in Excell and I would like to have a new
invoice number for every time i open up the template. Any idea? Thanks

 

[Paul B]

Kiddie, have a look here for ways to do it
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