Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automtically increase a number every time a file is used
With Excel, is it possible to generate automatically a sequence of number
that would increse by one (1) each time the file is used? As an example generate a new invoice number increasing by one (1) for each new invoice. If so, how is it done? Thank you for your help. -- Merci et bonjour falcp |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automtically increase a number every time a file is used
falcp, A simple way would be to use something like this, you could assign it
to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "falcp" wrote in message ... With Excel, is it possible to generate automatically a sequence of number that would increse by one (1) each time the file is used? As an example generate a new invoice number increasing by one (1) for each new invoice. If so, how is it done? Thank you for your help. -- Merci et bonjour falcp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
number of fields exceeds 256 when importing from a dbf file | Excel Discussion (Misc queries) | |||
Time as number | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |