ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   increasing a value everytime excel is opened? (https://www.excelbanter.com/excel-worksheet-functions/73159-increasing-value-everytime-excel-opened.html)

chris leight

increasing a value everytime excel is opened?
 
I would like i value in my sales invoice to increas by 1 everytime the file
is opened! (invoice number) what is the formula i use?

Peo Sjoblom

increasing a value everytime excel is opened?
 
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"chris leight" <chris wrote in message
...
I would like i value in my sales invoice to increas by 1 everytime the file
is opened! (invoice number) what is the formula i use?




All times are GMT +1. The time now is 06:16 PM.

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