Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically generate unique serial numbers for invoices | Excel Worksheet Functions | |||
Changing text dates to date serial numbers | Excel Worksheet Functions | |||
Serial number generate | Excel Worksheet Functions | |||
Changing date serial numbers | Excel Discussion (Misc queries) | |||
generate serial number | Excel Worksheet Functions |