Previous Topic Next Topic

Time recording on excel

Closed
leo - Mar 25, 2012 at 07:07 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 25, 2012 at 08:45 AM
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



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 25, 2012 at 08:45 AM
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
0

Similar discussions

How to send audio in Instagram
suyaprakash8429 -
Andy._Tani -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses