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
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
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:
- Time recording on excel
- Popcorn time download - Download - Movies, series and TV
- How to change time on whatsapp - Guide
- Ocarina of time rom - Download - Action and adventure
- Excel mod apk for pc - Download - Spreadsheets
- Messenger recording download - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 25, 2012 at 08:45 AM
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
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
