Here is a very simplified version of what I need help with. I'm trying to update dates people at my company put into our pto calendar in outlook in our availability spreadsheet.
On one worksheet I have a list of names in Column A and a list of dates across Row 1.
<tbody>
</tbody>
In another sheet, I have a list of names and dates being pulled from an outlook calendar. I have a vba pull these appointments and insert them into a separate sheet. It looks similar to -
<tbody>
</tbody>
My end goal is to automatically match these and input a "0" in the first calendar. Ultimately i'd like it to look like -
<tbody>
</tbody>
Any help would be super appreciated. I'm trying to automate things as much as possible.
On one worksheet I have a list of names in Column A and a list of dates across Row 1.
1/1/2018 | 1/2/2018 | 1/3/2018 | 1/4/2018 | |
Name 1 | ||||
Name 2 | ||||
Name 3 | ||||
Name 4 | ||||
Name 5 | ||||
Name 6 | ||||
Name 7 |
<tbody>
</tbody>
In another sheet, I have a list of names and dates being pulled from an outlook calendar. I have a vba pull these appointments and insert them into a separate sheet. It looks similar to -
start | end | ||
Name 1 | 1/2/2018 | 1/4/2018 | |
Name 3 | 1/1/2018 | 1/2/2018 |
<tbody>
</tbody>
My end goal is to automatically match these and input a "0" in the first calendar. Ultimately i'd like it to look like -
1/1/2018 | 1/2/2018 | 1/3/2018 | 1/4/2018 | |
Name 1 | 0% | 0% | 0% | |
Name 2 | ||||
Name 3 | 0% | 0% | ||
Name 4 | ||||
Name 5 | ||||
Name 6 | ||||
Name 7 |
<tbody>
</tbody>
Any help would be super appreciated. I'm trying to automate things as much as possible.