Hi Rohit
Please make following changes. Unprotect the sheets,password is "shiv".
Now let say if you want to change weekly off from Saturday to Friday in Jan, just copy cell G5:G34 and paste in F5:F34 and again copy data from I5:I34 and paste it to G5:G34. This will change your first weekly off. Similarly do it for all weekoff's in all months.
You can change ML (A11) to CL and change description as Casual Leave instead of Mandatory Leave. Same will be updated in all the sheets automatically.
Please try and let me know.
It will not be possible for me to work on individual request at this point of time as I am kinda busy now a days.
Regards,
Shiv
Please make following changes. Unprotect the sheets,password is "shiv".
Now let say if you want to change weekly off from Saturday to Friday in Jan, just copy cell G5:G34 and paste in F5:F34 and again copy data from I5:I34 and paste it to G5:G34. This will change your first weekly off. Similarly do it for all weekoff's in all months.
You can change ML (A11) to CL and change description as Casual Leave instead of Mandatory Leave. Same will be updated in all the sheets automatically.
Please try and let me know.
It will not be possible for me to work on individual request at this point of time as I am kinda busy now a days.
Regards,
Shiv