aligahk06
07-28-2019, 12:17 PM
Dear All,
I have a time card and i want to summarize under following condition.
1. based on timetable column E , all emp # i.e column A associated with same timetable should appear in one sheet or in sequence order. then next timetable with corresponding all employees and so on.
eg. emp# 17 consist of seven records starting week day from 16/7/2019 to 24/7/2019 and timetable name 08:00 - 16:00 .
So one timetable associated with all employee appear in one place and then next timetable with all employee at order or in separate sheets.
Please assist..
Rgds,
aligahk06
I have a time card and i want to summarize under following condition.
1. based on timetable column E , all emp # i.e column A associated with same timetable should appear in one sheet or in sequence order. then next timetable with corresponding all employees and so on.
eg. emp# 17 consist of seven records starting week day from 16/7/2019 to 24/7/2019 and timetable name 08:00 - 16:00 .
So one timetable associated with all employee appear in one place and then next timetable with all employee at order or in separate sheets.
Please assist..
Rgds,
aligahk06