DeadlyGentleman
New Member
- Joined
- Mar 31, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I am in need of assistance with creating a VBA. (below is an attached example document)
I am attempting to create a basic Time sheet for when employees clock in/out.
I am trying to get a macro that will search for the employee's name in the Groups portion of the document (Columns A, F, K, P) and check to see if their name appears in Column U.
Once a match is found, I want the macro to copy the timestamp next to the employee's name (Column V) and paste it next to the correct name in the Time In Column.
Then, do this for all employees as they clock in. However, I also need this to be able to look for the employee's name and check to see if the timestamp is after the time pasted in their "Time In" Column, in order to paste that new time as their "Clock Out" value.
Finally, I need the Macro to delete both rows for that name/timestamp in the responses section (Columns U:V) so that the entire cycle can repeat every day.
Thank you in advance. Any advice helps.
I am attempting to create a basic Time sheet for when employees clock in/out.
I am trying to get a macro that will search for the employee's name in the Groups portion of the document (Columns A, F, K, P) and check to see if their name appears in Column U.
Once a match is found, I want the macro to copy the timestamp next to the employee's name (Column V) and paste it next to the correct name in the Time In Column.
Then, do this for all employees as they clock in. However, I also need this to be able to look for the employee's name and check to see if the timestamp is after the time pasted in their "Time In" Column, in order to paste that new time as their "Clock Out" value.
Finally, I need the Macro to delete both rows for that name/timestamp in the responses section (Columns U:V) so that the entire cycle can repeat every day.
Thank you in advance. Any advice helps.