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.

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.

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.

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.