Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
What is the best way to generate an auto number, like an invoice number, on a
template so that each time a new workbook is created a sequential number appears thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
Hi Nigel
J E McGimpsey has some suggestions on his site at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Roger Govier "Nigel 2000" wrote in message ... What is the best way to generate an auto number, like an invoice number, on a template so that each time a new workbook is created a sequential number appears thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
Hi
I always use this for numbering documents, it might not be good code but it works well enough for me. EG: In cell A1 enter a number say 12345 Cell B1 enter 1 (the number you wish to increment by) Cell C1 = A1+B1 (your document no. = 12346) Use a button to operate the following code. Sub IncOrdNum() Application.ScreenUpdating = False Range("c1").Select Selection.Copy Range("a1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub Regards Steve "Nigel 2000" wrote in message ... What is the best way to generate an auto number, like an invoice number, on a template so that each time a new workbook is created a sequential number appears thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Numbering System | Excel Worksheet Functions | |||
Data tracking and auto sequential numbering | Excel Worksheet Functions | |||
Auto Numbering | Excel Worksheet Functions | |||
Auto Numbering | New Users to Excel | |||
Auto page numbering for several worksheets | Excel Worksheet Functions |