Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
project values based on other values | Excel Discussion (Misc queries) | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |