Dynamic Calendar from a Table of Values

[chandx]

Hi there!

Was wondering if anyone out there is able to share some guidance on my problem ahead..

I am hoping to create a dynamic calendar (that shows a daily view across different months of the year) to summarize the events happening daily.
But this needs to be auto-fetched from a 2nd sheet in the same document that has the following values in a table:

Event Name | Details of Event | Start Date | End Date

On my calendar view under the 1st sheet, I just need the event name populated under the respective dates from start till end.
Eg. My event is ABC Campaign, starting from 1 March till 5 March 2018.
Under the calendar, "ABC Campaign" will show up under the box with dates 1 - 5 March 2018.

Sincerely hope someone can help me with this

Thanks!

 

[chandx]

Anyone?

 

[Perpa]

chandx,
Have a look at this link, posts #17 to 24:

Excel's Magic Calendar

For over a decade I've missed two things in Excel. (Okay, I've really missed more than two, but this post is about the two that are on my mind at this moment.) One, a ruler like in Word and PowerPoint. And two, a Make Calendar button that lets you select a list of events, dates in the one...

www.mrexcel.com

The list for that list of events was set up on the same sheet as the calendar, and each date must be listed separately. The code can be modified to look for the Events/Dates on another sheet, Sheet 2. You could also modify the code to add the Event Name to each day between the Start and End Dates. As it is, the five (5 ) Event/Dates would have to be entered on 5 rows.
See if this is any help as a starting place.
Perpa