Auto populate and categorize calendar entries based on data ranges

Hello!

I am trying to have the calendar in the second tab of the attached excel file to auto populate based on information in the first tab. In the first tab, there is the start and end dates of certain projects. The calendar will need to show the project name (once) across the corresponding date ranges (there are examples in this website showing the project name every day but that is not what I want). There can be multiple projects taking place on the same date. In addition, I need the calendar to be populated for projects added or dates modified. It will be nice if each project can be shaded with the category color (but I can live without it).

Any help will be greatly appreciated.

Thanks for your help. I will try the macro.

Thanks. This is exactly what I need.