See

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

In article ,
"Michael1959" wrote:

I am creating a purchase requisition form and want to create a cell that
automatically creates a sequential number every time the file is opened. How
can this be done?