PDA

View Full Version : Summarized data based on timetable sequence



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