Reetika Choudhary
New Member
Hi I need help with the scheduling tool I am building.
Below is the list of requirements:
1. Based on the leaves table you need to change the shift time. If a person has taken 2 hours leaves from his regular day then the shift time should change accordingly for that particular day.
2. Once the user clicks on save button, The data should go and save in my access database with week number and team number.
3. Later when I refresh, the macro should first check the access database if the data for chosen week is available or not,, if not available then it should choose the default schedule for the employee from default schedule table and paste that against his name in scheduling table.
Thats it!
I am done with these but only problem I am facing is with identifying who is taking leave when and populating it in the table. Currently I am using INDEX MATCH function in excel which is able to identify only the first leave taken by the person n fails if the user took two leaves in a week.
Below is the list of requirements:
1. Based on the leaves table you need to change the shift time. If a person has taken 2 hours leaves from his regular day then the shift time should change accordingly for that particular day.
2. Once the user clicks on save button, The data should go and save in my access database with week number and team number.
3. Later when I refresh, the macro should first check the access database if the data for chosen week is available or not,, if not available then it should choose the default schedule for the employee from default schedule table and paste that against his name in scheduling table.
Thats it!
I am done with these but only problem I am facing is with identifying who is taking leave when and populating it in the table. Currently I am using INDEX MATCH function in excel which is able to identify only the first leave taken by the person n fails if the user took two leaves in a week.