Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto numbering
Hi Christiana,
You probably need VBA. Try this... Copy below to the ThisWorkbook sheet code. --------------------------------- Private Sub Workbook_Open() [A1] = [A1] + 1 End Sub --------------------------------- Hope this helps... Chong Moua -----Original Message----- I would like to create a field that with contain a number which will be increased next time you will open the particular file. Basically what I have is an Invoice speadsheet and I want the Invoice number to be entered automatically each time someone opens the file. How I will do that? should I need VBA for this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aUTO nUMBERING | New Users to Excel | |||
Auto Numbering | Excel Discussion (Misc queries) | |||
Auto Numbering | Excel Discussion (Misc queries) | |||
auto numbering | Excel Discussion (Misc queries) | |||
auto numbering | Excel Discussion (Misc queries) |