This has to be a contender for the most commonly asked question and you can
find the best methods here

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

Mike

"scooterboy65" wrote:

I want to produce training certificates that number themselves automatically
any ideas?