autonumber values

[rlmanderson]

Is there a way to make a cell obtain a formula that will update a number each
time you open the worksheet? For example I created my own invoice and I want
to start my invoices at 1000 and then each time I open it to create a new one
that number would automatically update one so it would be 1001 . . . . 1002 .
.. . . 1003 etc. etc. I've looked and looked and can't figure out how to do
it and I'm sure it's possible. Please help!

[Gord Dibben]

JE McGimpsey's site has code you can use.

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


If not familiar with macros, see David MCRitchie's site for getting started.

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Gord Dibben Excel MVP

On Thu, 10 Mar 2005 15:19:04 -0800, "rlmanderson"
<[email protected]> wrote:

>Is there a way to make a cell obtain a formula that will update a number each
>time you open the worksheet? For example I created my own invoice and I want
>to start my invoices at 1000 and then each time I open it to create a new one
>that number would automatically update one so it would be 1001 . . . . 1002 .
>. . . 1003 etc. etc. I've looked and looked and can't figure out how to do
>it and I'm sure it's possible. Please help!