See this:

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

--
Biff
Microsoft Excel MVP


"CLAYSHELLY" wrote in message
...
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.