ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Make sequential numbers each time sheet is opened (https://www.excelbanter.com/excel-worksheet-functions/51112-make-sequential-numbers-each-time-sheet-opened.html)

Darrell Shuman

Make sequential numbers each time sheet is opened
 
I would like to have a cell reflect a sequential number each time this
spreadsheet is opened. It will be a purchase order sheet and will be on a
server and accessed by several users. I guess it is similar to invoice
numbers so if you have any thoughts on control issues that would be
appreciated as well.
Thank you very much,
Darrell



JE McGimpsey

Make sequential numbers each time sheet is opened
 
See

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

In article ,
"Darrell Shuman" wrote:

I would like to have a cell reflect a sequential number each time this
spreadsheet is opened. It will be a purchase order sheet and will be on a
server and accessed by several users. I guess it is similar to invoice
numbers so if you have any thoughts on control issues that would be
appreciated as well.
Thank you very much,
Darrell



All times are GMT +1. The time now is 02:19 AM.

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