Sequential Cell Numbering

[shejinummer]

I want to serialise a cell in the workbook i.e. whenever i create or copy a new work sheet, it has to give me a new following serial , like in invoices...

need help please

[Simon Lloyd]

I want to serialise a cell in the workbook i.e. whenever i create or copy a new work sheet, it has to give me a new following serial , like in invoices...

need help pleaseHow will you create the copy? will it be via code or manually?

[shejinummer]

create the sheet manually, but giving a vbscript to the workbook

[Simon Lloyd]

Well, you could add a macro button to your toolbar and click it to make a copy using this code, but beware it is set to work on the active sheet, it works on the basis of increasing a number in a cell (in this case A1).

Dim MySheet
MySheet = ActiveSheet.Name
ActiveSheet.Copy Before:=Sheets(1)
ActiveSheet.Name = ActiveSheet.Range("A1")
Sheets(MySheet).Range("A1") = Sheets(MySheet).Range("A1") + 1
Sheets(MySheet).Activate

[Bob Phillips]

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