Hello,
I'm making the schedule for my employees and I was wondering if there is a macro that would automatically create a tab with a template for the next week and rename that tab with the date of that week.
Thank you
<tbody>
</tbody>
I'm making the schedule for my employees and I was wondering if there is a macro that would automatically create a tab with a template for the next week and rename that tab with the date of that week.
Thank you
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |||||
1/1/2018 | 1/2/2018 | 1/3/2018 | 1/4/2018 | 1/5/2018 | 1/6/2018 | 1/7/2018 | |||||
Position1 | current | YTD | relief | YTD | |||||||
employee 1 | off | off | |||||||||
Position2 | |||||||||||
employee 2 | off | off | |||||||||
employee 3 | off | off | |||||||||
employee 4 | off | off | |||||||||
Position3 | |||||||||||
employee 6 | off | off | |||||||||
employee 7 | off | off | |||||||||
Position4 | |||||||||||
employee 8 | off | off | |||||||||
employee 9 | off | off | |||||||||
employee 10 | off | off | |||||||||
employee 11 | off | off | |||||||||
employee 12 | off | off | |||||||||
employee 13 | off | off | |||||||||
employee 14 | off | off | |||||||||
employee 15 | off | off | |||||||||
employee 16 | off | off | |||||||||
employee 17 | off | off | |||||||||
employee 18 | off | off | |||||||||
employee 19 | off | off | |||||||||
section1 | section2 | section3 | section4 | section5 | section6 | section7 | |||||
section8 | |||||||||||
1234 | 5678 |
<tbody>
</tbody>