1.Extract Active Employee Data & conditionally format extracted records

http://www.hrknowledgecorner.com/excel-macros-extract-active-employee-data-conditionally-format-extracted-records/

2.Excel Macros Series 2: Calculate the total paid days from the attendance roster for a particular month

http://www.hrknowledgecorner.com/excel-macros-series-2-calculate-total-paid-days-attendance-roster-particular-month/