Log in time excel Sheet

[vanamasatish]

In Excel Sheet, in column A if we write the names then the system time will automatically displayed in column B.

Ex:

Column A Column B satish 10.00 AM ramesh 10.05 AM venkat 10.02 AM


How it is possible in excel?


please give me ans.

 

[Hui]

Vanamasatish


Firstly, welcome to the Chandoo.org Forums


You may want to search for Time Stamp in the Google search box at the top right of this screen

 

[mahaveer]

you can put the following code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("a1").Value <> "" Then

Range("b1").Value = Time

End If

End Sub


Regards

Mahaveer Somani