ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I generate a new invoice number when creating new invoice? (https://www.excelbanter.com/excel-discussion-misc-queries/77360-how-do-i-generate-new-invoice-number-when-creating-new-invoice.html)

KiddieWonderland

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

Paul B

How do I generate a new invoice number when creating new invoice?
 
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

"KiddieWonderland" wrote in
message ...
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





All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com