I post it on ozgrid.com but got no response after 2 days. I hope someone could help me here
Search matching 3 columns
I have 2 sheets
1 is the raw data and the other is the output
the raw consists of 5 columns
1 2 3 4 5
name type of time log date time shiftdate
the output should be
1 2 3 4 5
name time in time out time late shiftdate
now, im succesful in extracting the time in data but not the time out data. I've constructed a code where in it will make sure that the "Time OUT" "Shift Date" and Name should match then it would return the time corresponding to the "Time OUT". I've used if else statement.
The problem is, it will only look for the name and time out but it will disregard the date. It will search for the first row that will match the name and "Time OUT" not the date
How to solve this? thanks!
ProTimeOut Executes the command
If you have a better suggestion, feel free to tell me.
Thanks in advance!
VB:
Across the board I have come up with this. Match formula works in excel not in vba. pls help
VB:
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I also want to implement this for errors:
VB:
Bookmarks