Formulas to Enter Events in Calendar Sheets

Hello,

Is it possible to have formulas to put the descriptions from the Events! sheet to the matching days in the calendars sheets? I put just a few examples of course there will be many more for the year.

Thank you for any help,
XJ

Why not just use the macro for adding holidays & change the sheet name in the code to Events

Thank you for the reply but will that work?

As long as the Event sheet & Holiday sheet are setup the same, then it should do.

I tried that but it replaces the Holiday if there is one there.

Maybe the code can be altered to incorporate both sheets (Holidays and Events)?

I tried an example see January 21.

How about

Please Login or Register  to view this content.

Note the change in the Clearcells code

That works great thank you very much. I think this should cover the Holiday and up to 4 additional events for the same day.

Just curious if I face a very busy day and need more what are my options?

Cancel an appointment

Either concatenate some of the events together in one cell, or increase the number of cells available.

Thank you Fluff I will make some notes for those ideas.