ExcelBanter - View Single Post - I need a unique number to be created per worksheet

See

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

In article ,
Roy Tamir <Roy wrote:

I am using excel for a warranty claim form I created. Need a unique numbering
system to create a unique identification number per form as soon as I open
it. Once saved as a filled up warranty claim, I want that field/cell to keep
this number but when I open this form as a template, I want a unique number
created and given to it on the designated cell called 'Warranty claim number
____'