Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to show time that data was entered on spreadsheet
I want to know if its possible for the time to automatically appear in a
seperate cell when data is entered in a cell. For example, in cell A1 i enter the figure 3, in cell A2 the time i entered that number appears as hh.mm.ss. In cell B1 i enter the figure 4 & in cell B2 the time appears again in hh.mm.ss. Is this possible and how do i achieve it please. Thank you in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to show time that data was entered on spreadsheet
Hi,
You need a macro for that but it's easy. Right click your sheet tab, view code and paste the code below in on the right and that's it. Close VB editor Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub If Not Intersect(Target, Range("1:1")) Is Nothing Then On Error Resume Next Application.EnableEvents = False Target.Offset(1) = Format(Time, "hh:mm:ss") Application.EnableEvents = True On Error GoTo 0 End If End Sub Mike "Irmatwit" wrote: I want to know if its possible for the time to automatically appear in a seperate cell when data is entered in a cell. For example, in cell A1 i enter the figure 3, in cell A2 the time i entered that number appears as hh.mm.ss. In cell B1 i enter the figure 4 & in cell B2 the time appears again in hh.mm.ss. Is this possible and how do i achieve it please. Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I record the time data is entered into a spreadsheet? | Excel Worksheet Functions | |||
Show a time 50 min before entered time | Excel Discussion (Misc queries) | |||
Show zero values only when data is entered in other fields | Excel Discussion (Misc queries) | |||
Show time stamp when a value is entered | Excel Discussion (Misc queries) | |||
Formula does not show as I entered it. | Excel Worksheet Functions |