Generate auto Timetable Randomly :confused:

Respectable Greetings to all Excel Guru, Expert, Contributor, and every one

I am running into big problem and challenge

I have two sheets called “Timetable” sheet & “Teachers Details” sheet. what i am trying to accomplish is to generate auto Timetable Randomly, but i m confuse and not getting any idea + solution how it will done..

i want to pick data/details from “Teachers Details” sheet and create automated timetable in “Timetable” sheet so that my huge time which is wasted to create manually timetable can be safe.

plz find the attach excel sheet
Time table high school.xls

Sample Excel Sheet imge
Sample Timetable.jpg

Right now i am creating timetable manually
Now here is how it works:
1. you click on any cell where you want to create a new course. You set it as you wish regarding the merged cells prior to click on the button.
2. you click on the button which will open a userform divided in 3 sections First part is the matter of the course. You write directly in the texbox (like Math or Bio or Physics). Second part is the teachers' selection. it is a listbox that allow multiple selection. You hold the CTRL key and click on as many teachers as you like. Thrid part is the location of the course. You write directly into the textbox.
3. when you are done, you click on the left button at the bottom to transfer all the information into the selected cell. The macro will add a line feed between each section.

i dont know will “VB/Macro Code” will do it or excel Formula will solve it. plz Help

ANY help from any one will be great help and highly appreciated

Best Regards

Bump No Reply