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

Copper Contributor

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.

 

1 Reply

@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.