From the template; launch VBE using Alt+F11. From the left treeview search
for the VBA project for this template workbook and click + to expand the
modules..Double click on 'This Workbook' and paste the below code....Adjust
sheetname and cell A1 to suit your requirement...now save and close..

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1") = Sheets("Sheet1").Range("A1") + 1
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"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.