I've been attempting to find the resolution for this for a few days now and coming up short.
I have a large data sheet that pulls information into a table. In this table there are quite a few columns each with specific data (names, locations, etc...) and included in that data are date ranges. What I need to create is a visual calendar view that pulls the start and end date and plots them into a visual. This would need to be specific to the name on the left so if "employee 1" has an activity with a start date of 3/4/19 and an end date of 3/25/19 I need it to show these in a different color. In the image below my "data" is off to the right as an example. It would be on a different sheet within the same workbook in reality.
visual_cal.JPG
Hopefully this makes sense, please let me know if there are any additional questions I can help with.
Bookmarks