VBA code to associate Agenda start time with Timetable view start time and end time

[Coretex]

Hello Forum!

I was wondering if you could help me with a little problem I am having. I have an Agenda sheet for the days of the week, and a Schedule timetable sheet. Basically I have a dropdown of a start time for a certain module on the agenda sheet (Day1 B:10) it currently checks the value of the dropdown and adds it into the Schedule view in the one cell for that day. =IF(B:10=B3,moduleInfo," ")

I need this to be smarter, and i am having a hard time doing it. I need some VBA code so it can smartly see the start asnd end time from the dropdown box and add it to the timetable view, and then merge the cells together.

The issue I have at the moment is that I have to manually merge the cells, and then the cells lose there formula :S I will attach the sheet, any help would be much appreciated. Thanks

 

[Coretex]

EDIT: Just realised I cannot upload the doc so here is a picture, thanks Imgur: The most awesome images on the Internet