I have a problem regarding the preparation of monthly schedules. Due to:
The number of staff exceeds the number of days in that month.
There MOD officials who can not perform their duties on certain days such as Puji Ariyani and Suryanti. Their can't perform their duties from Fri to Sun.
My Question is:
How to make automatic generated monthly schedule of person who incharge MOD?
How to make the rest person to do the MOD in the next month automatically? Because in one month have 28 to 31 days but the person incharge more than 40 attendant.
Herewith I attach an example of data in question.
Thanks for your help.
Hey Erwinar,
Your attachment is not visible. Please attach again.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks