I have a Excel (employees attendance sheet) generated from a database. My requirement is to make a new excel with Employee code, Employee name and status. The status has two values “Present and Absent” . Here i need employees with only absent status in my new excel. Here in the excel I have report of 1 month. so after every date there is break in the sheet. refer below image.
I tried to implement it but unable to write them to a new excel. Kindly help in providing the solution. For reference i’m attaching the excel here. Your help is much appreciated.
Daily_Attendance_Report_Feb2019.xls (33.5 KB)
Thank you all.