Hi,
I am task to create a leave balance report. I would like to ask how do i linkup using data validation to show the used leave and balance leave in the list below. Is there any way whereby i can select from the dropped down list, for example when i selected "USED" the data below will show only the used leave. And when i selected "BALANCED" it will only show balance leave.
Appreciate help on that.
Thank you.
I am task to create a leave balance report. I would like to ask how do i linkup using data validation to show the used leave and balance leave in the list below. Is there any way whereby i can select from the dropped down list, for example when i selected "USED" the data below will show only the used leave. And when i selected "BALANCED" it will only show balance leave.
Appreciate help on that.
Thank you.