SILENT_GHOST
New Member
- Joined
- Sep 13, 2018
- Messages
- 1
Please can you help me make an application that make a security gards duty.
1 - in the first sheet the table is like that:
name - last date (mon to friday) - last date saturday - last date sunday
2 - in the second sheet the history for every gard duty
name - 1-2-3-4-5- ........31(january days)
adam x x x
sam x x
3 - in the third sheet with macro when I click a button the result is the next week duty according to the last date for every gard
4 - exeptions to be enter on the fourth sheet
adam is not available from 10/9/2018 to 20/9/2018 for exemple
thank you
1 - in the first sheet the table is like that:
name - last date (mon to friday) - last date saturday - last date sunday
2 - in the second sheet the history for every gard duty
name - 1-2-3-4-5- ........31(january days)
adam x x x
sam x x
3 - in the third sheet with macro when I click a button the result is the next week duty according to the last date for every gard
4 - exeptions to be enter on the fourth sheet
adam is not available from 10/9/2018 to 20/9/2018 for exemple
thank you