KidlatKulug1
New Member
- Joined
- Nov 8, 2021
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Pls help me create a macro to get columns value from worksheet "Lab Tech" the Times and Day X of rolling 6 days rotation that correspond to current school calendar year (using weekdays only). Start with, If the input date is todays date (11/8/2021) the date falls on day 2 rotation (output are the column TImes and Day 2. Note that the Input and Output is on different worksheet "Master". If the input is on 11/9/2021 day 3 rotation, the output is the Column Times and Day 3, on 11/10/21 is day 4 rotation, and 11/11/21 no rotation since its holiday, continue on 11/12/21 is day 5 rotation, 11/15/21 day 6 rot, 11/16/21 back to day 1 rotation, 11/17/21 day 2 rotation and so on. Note that on holidays there are no Lab day and also following dates there are no Lab day (11/24/21, 12/17-1/3/22, 2/21/22, 3/14/22-3/28/22, 4/15/22, and 5/27/22-7/4/22), which means it will pick up the day of rotation where last left off (ie..12/17/2021-1/3/2022 no lab day so on 1/4/2022 its day 3 rotation and 1/17/22 no lab so 1/18/22 is day 6 rotation). Below is worksheet "Lab Tech".
LAB Tech | ||||||
TIMES | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 |
8:45-9:25 | Inter MUN | ADMIN | Inter BAR | Inter Van | Inter FAK | ADMIN |
9:30-10:10 | ADMIN | Campbell | Hess | Tubolino | ADMIN | Sears |
10:15-10:55 | Yontez | Scherr | ADMIN | Mehl | ADMIN | Valdivia |
11:00-11:40 | ADMIN | Falconer | Robertson | ADMIN | Harris | Brekke |
11:40-12:30 | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH |
12:30-1:10 | Lee | K RTI | K RTI | K RTI | Contreras | Jacobs |
1:15-1:55 | Lenz | Benson | Pennington | Bailey | Frasier | Monaco |
2:00-2:40 | Nothrop | Carlson | Lauder | Rhodes | Brandt | Gonzales |