software

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

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(quot;Sheet1quot;).Range(quot;A1quot;).Value = _
Sheets(quot;Sheet1quot;).Range(quot;A1quot;).Value 1

For other ways to do this or if this is going to be used in a temple have a
look here
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 amp; 2003

quot;falcpquot; gt; wrote in message
...
gt; With Excel, is it possible to generate automatically a sequence of number
gt; that would increse by one (1) each time the file is used? As an example
gt; generate a new invoice number increasing by one (1) for each new invoice.
If
gt; so, how is it done? Thank you for your help.
gt; --
gt; Merci et bonjour
gt; falcp