Populating Selected Result from Master Data Worksheet

[Pushppreet]

Hi Excel Gurus,

I am not sure how to do this and I need your help:

In 1st worksheet (Daywise View) what I want is that when I select the month on top, ONLY the training names should get reflected in front of the each day of month. This should only show the names of trainings planned on that day only.
The result should be from the fourth sheet "Calendar" A4 to A110 only. I do not want the off days to be calculated like I have in "Trainers Schedule" worksheet.

Can someone please work on this and even teach me how they did it. Since I am an amateur and learning excel, I will not be able to do this on my own.

Appreciate your help.

Regards,
Pushppreet

 

[Chihiro]

In C4:
=IFERROR(INDEX(Calendar!$A$4:$A$110,SMALL(IF(INDEX(Calendar!$D$4:$ND$110,,$B4-DATE(YEAR($B4),1,0))<>"",ROW($D$4:$D$110)-3),COLUMN(A1))),"")

Confirmed as array (CSE). Copy down and across.

See attached. Same principle used from previous (just the dimension changed as you are now listing days vertically).

 

[Pushppreet]

In C4:
=IFERROR(INDEX(Calendar!$A$4:$A$110,SMALL(IF(INDEX(Calendar!$D$4:$ND$110,,$B4-DATE(YEAR($B4),1,0))<>"",ROW($D$4:$D$110)-3),COLUMN(A1))),"")

Confirmed as array (CSE). Copy down and across.

See attached. Same principle used from previous (just the dimension changed as you are now listing days vertically).

Hey Chihiro,

Thanks a lot for your help. This works very well.

Regards