shaftdx
Board Regular
- Joined
- Aug 20, 2018
- Messages
- 136
- Office Version
- 2011
- Platform
- MacOS
I have 2 worksheets one has a list of the dates this month going down in Column A. Column B has a list of names that rotate So for today Carla is on call. tomorrow will be john Ect ect till the list is complete and starts over.
Without getting too technical I have a Zapier that adds to the group calendar who is on call from the second worksheet. What I am looking to do is to automate this.
So basically what I am looking to do is tomorrow when that date is highlighted I want the date and the first name on the list next to it to appear in B2 and D2 of the second pic. and when it is thursday Maria will appear in D2 I feel like I am explaining this poorly I am sorry
Without getting too technical I have a Zapier that adds to the group calendar who is on call from the second worksheet. What I am looking to do is to automate this.
So basically what I am looking to do is tomorrow when that date is highlighted I want the date and the first name on the list next to it to appear in B2 and D2 of the second pic. and when it is thursday Maria will appear in D2 I feel like I am explaining this poorly I am sorry