autonumber values
 

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!

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"
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!