Can I set a spreadsheet to sequentially number the sheet?

[CLAYSHELLY]

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.

 

[T. Valko]

See this:

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

 

[Jacob Skaria]

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

 

[Eduardo]

Hi,
look into McGimpsey web

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

if this helps please click yes, thanks