Formulas to Enter Events in Calendar Sheets

[xjohnson]

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

[Fluff13]

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

[xjohnson]

Thank you for the reply but will that work?

[Fluff13]

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

[xjohnson]

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

[xjohnson]

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

[xjohnson]

I tried an example see January 21.

[Fluff13]

How about

Please Login or Register  to view this content.

Note the change in the Clearcells code

[xjohnson]

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?

[Fluff13]

Cancel an appointment

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

[xjohnson]

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