Mahantesh_Torgal
New Member
- Joined
- Sep 12, 2016
- Messages
- 23
Hi All,
I am working on building Leave Tracker using VBA Excel(Userforms), my manager has asked me to include one feature: "Auto-Crediting Leaves on every 1st of the New month":
What I have done?
___________________________
I have one "Master.xlsx" where I have maintained every employee's details of Earned Leave (EL) and Casual Leave (CL), and have a front end user-form to apple leaves which is working fine.
Now What I am looking for is, I need to update existing EL's by 1.5 and CL's by 0.5 on every 1st Day of the new Month without opening the "Master.xlsx" workbook. i.e. auto-Crediting the leaves to all the employees.
Please help me with this!!!
Regards,
Mahantesh
I am working on building Leave Tracker using VBA Excel(Userforms), my manager has asked me to include one feature: "Auto-Crediting Leaves on every 1st of the New month":
What I have done?
___________________________
I have one "Master.xlsx" where I have maintained every employee's details of Earned Leave (EL) and Casual Leave (CL), and have a front end user-form to apple leaves which is working fine.
Now What I am looking for is, I need to update existing EL's by 1.5 and CL's by 0.5 on every 1st Day of the new Month without opening the "Master.xlsx" workbook. i.e. auto-Crediting the leaves to all the employees.
Please help me with this!!!
Regards,
Mahantesh