Forum Discussion

terenceli35's avatar
terenceli35
Copper Contributor
Jun 30, 2022

How to use Excel showing staff's attendance record by selected date and time?

I'm struggling in figure out how to show staff's attendance record by selected date and time in Excel. 

 

For example, we have 20 employees and I recorded which working day they attended and which working day they had already applied sick leave (SL), Leave (L), Time off (TO) etc. 

 

Do anyone know how to set VBA or other functions to develop a searching system that user can select date and time (AM/PM) and show that day's attended employee, employee(s) applied sick leave (which the data was in Sheet 2)? 

 

Thank you for your kind attention.

 

Formulas and Functions
Macros and VBA

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jun 30, 2022

    terenceli35 If you are using a modern Excel version you can probably use the FILTER function or, when the data is structured correctly you can perhaps create reports using pivot tables.

Resources