| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i set number in cell to add 1 upon opening sheet
I agree with what Joel wrote:
But you may want to look at the way J.E. McGimpsey approached it: http://mcgimpsey.com/excel/udfs/sequentialnums.html Office Admin wrote: I am setting up a workorder sheet that will be printed and saved. I would like the workorders to have numbers automatically - the number in the cell would increase by 1 each time I opened the master sheet. Is this a macro, a button? I have Excell 2003. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find an exact number in a different sheet and use the cell containing the number to output information | Excel Programming | |||
| opening sheet, next available cell displayed | New Users to Excel | |||
| Highlight cell with lower number than one on another sheet | Excel Discussion (Misc queries) | |||
| Extract sheet name/number to cell | Excel Discussion (Misc queries) | |||
| Excel macro - Opening a sheet in accordance with the value in a particular cell | Excel Programming | |||
Threaded Mode
