ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   number up one (https://www.excelbanter.com/excel-worksheet-functions/159509-number-up-one.html)

snowbugger

number up one
 
I would like to know how I can have an Invoice number change from say 7200 to
7201 after the doc is saved so I don't have to do it manually every time I
write an invoice.

Pete_UK

number up one
 
Follow this link:

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

Hope this helps.

Pete

On Sep 25, 12:20 am, snowbugger
wrote:
I would like to know how I can have an Invoice number change from say 7200 to
7201 after the doc is saved so I don't have to do it manually every time I
write an invoice.





All times are GMT +1. The time now is 09:36 AM.

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