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

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

******, 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

"KiddieWonderland" <[email protected]> wrote in
message news:[email protected]...
> 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