glorypeter91
New Member
- Joined
- Jun 5, 2018
- Messages
- 1
i NEED HELP TO LOOK UP BASED ON CRITERIA
1. NAME
2. DATE RANGE
FILES : TIMEDB AND PAYROLL
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
NOW I WANT TO SEARCH BY NAME AND DATE RANGE AND FILL THE FOLLOWING CELLS :
<colgroup><col><col><col><col><col span="29"><col></colgroup><tbody>
</tbody>
Please Advise Tq
1. NAME
2. DATE RANGE
FILES : TIMEDB AND PAYROLL
NAME | DATE | TIME IN | TIME OUT |
YOGHESRAJ A/L PERUMAL | May 2, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 3, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 4, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 5, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 6, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 7, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 8, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 9, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 10, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 11, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 12, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 13, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 14, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 15, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 16, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 17, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 18, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 19, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 20, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 21, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 22, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 23, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 24, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 25, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 26, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 27, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 28, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 29, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 30, 2018 | 8:00 | 22:00 |
YOGHESRAJ A/L PERUMAL | May 31, 2018 | 8:00 | 22:00 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
NOW I WANT TO SEARCH BY NAME AND DATE RANGE AND FILL THE FOLLOWING CELLS :
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | ||
Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | ||
START WORK | IN | |||||||||||||||||||||||||||||||
OUT | ||||||||||||||||||||||||||||||||
BREAK TIME | IN | |||||||||||||||||||||||||||||||
OUT | ||||||||||||||||||||||||||||||||
OVERTIME | IN | |||||||||||||||||||||||||||||||
OUT |
<colgroup><col><col><col><col><col span="29"><col></colgroup><tbody>
</tbody>
Please Advise Tq