EXCEL-VBA How to combine between these elements?

I have to create a Time table including the Subjects + their content, and i need to combine between all these elements.. anyone can help?

Hi,

Your request is quite short. Can you explain a little bit more and provide us with a sample excel file with some basic datas and the expected results ?

Sorry for not clearing the things, it's something like this , so what i'm looking for is a fucntion that allows me to see the content of each day only by clicking on the day ( like when i click on Monday, it shows automaticly the subject and its content..)

Hi,

a proposal. select the day in L5, check if this works for your excel version.

You speak french, don't you? you can post your message in the french speaking part of this forum.

Thank you for the solution, Merci beaucoup!