Formula to auto update Calendar entries

[anuradhagrewal]

Hi
I need a formula to create entries in a calendar
In worksheet named "Input" if I enter a detail column B named Event 1 (against in against Column A10 in date 08-May-24) then the output of that be automatically be listed in worksheet named Table in E9.
Similarly all empty columns should have the color as in the worksheet B4.

Can I please have the formula for this
Also I need to make this for every month and the date automatically should be updated in worksheet named Table. For eg the Table for June should start automatically from H4.

Please help me in this

Regards

Anu

 

[awoohaw]

Anu,
Would you be kind enough to post an xl2bb mini sheet, a table, or a picture (least preferred) of your two sheets?

 

[Sanjeev1976]

Hi Anu,
You can download the updated file from the below link:
Calendar

 

[anuradhagrewal]

Hi Anu,
You can download the updated file from the below link:
Calendar

Hello
I cant access the file
Please provide access