This is an attendance sheet of my company. Each employee has his/her TimeIn and TimeOut corresponding to their name and employee ID. I had written a macro which will cross-check In time and Out time and put comments with respect to that.
For eg:-
1. Employee ABC has logged in @ 9.30 and has missed to punch log out then that logout cell will have "MP" in it.
2. Employee ABC has missed punched his logging time and log out @ 17:00 then that login cell will have "MP" in it.
3. Employee ABC has no login and has no logout value then both the cell will have "A" in it.
But the macro is working only for two cells.
I want to apply all through the data table. Please help me to sort out this. My excel file is attached hereby.
Thanks and regards
Bookmarks