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