Hi Champs,

I have a worksheet with 30 tabs (current month's date) with name, id and attendance.

Attendance is marked as "yes" if they are present and left as blank if they are absent.

i need a macro to calculate all the person's attendance in a seperate worksheet in any business day. for example if i want to calculate from 1st to 15 month of this month, the macro need to get my input date and output date and generate the result as i said.


Pls help me and i have also attached sample for the reference.

the sample has NOV1 to NOV30 tabs and Output TABAttendance tracker sample.xlsx