Hi,
look into McGimpsey web

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

if this helps please click yes, thanks

"CLAYSHELLY" wrote:

I NEED TO CREATE A SPREADHSEET TEMPLATE AND PLACE A NUMBER ON THE SHEET,
ENTER DATA AND CLOSE/SAVE THE SHEET, THEN OPEN THE TEMPLATE AGAIN AND HAVE IT
AUTOMATICALLY OPEN WITH THE NEXT SEQUENTIAL NUMBER.