ExcelBanter - assign an incremental number to a cell, for each new spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - assign an incremental number to a cell, for each new spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/147359-assign-incremental-number-cell-each-new-spreadsheet.html)

MarkWatson

assign an incremental number to a cell, for each new spreadsheet

Can someone advise as the formula required to be entered into a cell, that
allocates a new incremental number each time a spreadsheet of the same name
is opened (like creating a new invoice individual invoice number for each
spreadsheet)

All times are GMT +1. The time now is 11:33 PM.