Time recording on excel

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
How can I have a code so that an employee just types his Employee # in let's say cell K1 and hit enter, so it will trigger the necessary input (like in the answer "1") on their corresponding cell for his employee number.
Example employee 351, types this number on cell K1, and a "1" is inputed on cell A351 and records the time and date.
Thanks guys



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you need to code for event
Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

The basic idea would be capture the employee id, search of that id in the appropriate column and once found make the changes that you want to make