generate serial numbers and date it entered
 

i am looking for formula to generate serial numbers and date, and when i
enter qty other cells filled with data.
so:
qty serial start serial last date
5 00001 00004 090730
3 00005 00007 090730

and so on

thank you for your help.

generate serial numbers and date it entered
 

Hi here is how acheived what you are looking for: (In Excel 2003)

Let's assume that everything starts in cell a1.

Qty Start Serial End Serial
5 1 =a2-b2
3 =c2+1 =b3+a3-1

Copy b3 to c3 down however many rows you need. To get the leading zeros you
will have to create a custom format:
Select a cell or cells affected
Select Format from the menu
Select cells
Select the Number tab in the dialog box
Select Custom
Type 0000# in the Type text box. Copy the format to all of the cells
affected.

If this helps please press Yes

John

"irealtymods" wrote:

i am looking for formula to generate serial numbers and date, and when i
enter qty other cells filled with data.
so:
qty serial start serial last date
5 00001 00004 090730
3 00005 00007 090730

and so on

thank you for your help.

generate serial numbers and date it entered
 

its not what im looking for,
i thought some script like this i found for date:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("F:F")) Is Nothing Then
With Target
If .Value < "" Then
..Offset(0, 6).Value = Format(Now, "yymmdd")
End If
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub



now i have already like this:
E3 qty
F3 =SUM(G2+1)
G3 =SUM(G2+E3)

if this is the only way, ok, but i like to see something more

thank you

generate serial numbers and date it entered
 

cause i don't like to have all cell filled with numbers(copied with formulas)
i need to see changes in cells where i am now. line by line