Jasmine1508
New Member
Dear Experts.
I need help from you in the following sheet with the usage of vba codes. In the attached sheet, i need to add up the following criterias in addition to present, absent, half-day.
Additions to be done : LOP, L (Leave) ,H (Holiday) and respective columns at end to be added for those.
Half-day which is already there as H is to be changed as Hlf-d
Main change required is ,
At first time, we want to specify the holidays & week-days for the month using any drop-down or selection or automation for the month (Notmally saturday or saturday & sunday).
Then, Just we need to specify the Leave & LOP while processing the attendance during salary process for attendance calculation.
Other than these specified details of days, all other days should automatically to be marked as present with the press of a command button or like and totals of individual columns at the end of columns needs to be updated.
One more help i need is , since the attendance cycle varies from one client to another, like 1-30 or 10-10 like that, please provide model code for two clients with different attendance cycle that follows the same above criterias.
I hope this is little more. since i am a fresher of codes and this is the model sheet, i need your assistance on this.
Thank you to all. I tried from internet other sources. i have not got my requirements. hence i am requesting you people.
Best Regards.
Jasmine
I need help from you in the following sheet with the usage of vba codes. In the attached sheet, i need to add up the following criterias in addition to present, absent, half-day.
Additions to be done : LOP, L (Leave) ,H (Holiday) and respective columns at end to be added for those.
Half-day which is already there as H is to be changed as Hlf-d
Main change required is ,
At first time, we want to specify the holidays & week-days for the month using any drop-down or selection or automation for the month (Notmally saturday or saturday & sunday).
Then, Just we need to specify the Leave & LOP while processing the attendance during salary process for attendance calculation.
Other than these specified details of days, all other days should automatically to be marked as present with the press of a command button or like and totals of individual columns at the end of columns needs to be updated.
One more help i need is , since the attendance cycle varies from one client to another, like 1-30 or 10-10 like that, please provide model code for two clients with different attendance cycle that follows the same above criterias.
I hope this is little more. since i am a fresher of codes and this is the model sheet, i need your assistance on this.
Thank you to all. I tried from internet other sources. i have not got my requirements. hence i am requesting you people.
Best Regards.
Jasmine