Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i set number in cell to add 1 upon opening sheet
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i set number in cell to add 1 upon opening sheet
Does this really make sense (create new order when opened)? What happens if
somebody want to look at the worksheet and not create a new Order? It is better to create a new number using a button or when somebody starts typing in a specific cell. "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. |
#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 |
Reply |
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 |