generate work schedule

[pipsmultan]

Respectable Greetings to all

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..

Two sheets in my excel file are

1. Teachers Details (Sheet).
2. Timetable (Sheet)

plz see the attachment of excel sheet
View attachment Time table high school_V1.xls


Now i am trying to achieve is when anyone enter the detail of a teacher in Teachers Details (Sheet) with the following credential like (which subjects he can teach, which classes he can teach, and in which periods). Excel auto generate timetable from the following given details.

1. Teaching Subject
2. Teachers Name
3. Enter Teaching Class
4. Enter Period (Optional)

plz see the image

i dont know will “VB/Macro Code” will do it

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

Best Regards

 

[Herbds7]

Excel 2010 with free Power Query Add-In.
Compatible with Office 2013 Pro Plus.
No formulas, no VBA macro.
http://www.mediafire.com/view/wjcc1pb7owy2hba/05_18_15.xlsx

 

[pipsmultan]

Excel 2010 with free Power Query Add-In.
Compatible with Office 2013 Pro Plus.
No formulas, no VBA macro.
http://www.mediafire.com/view/wjcc1pb7owy2hba/05_18_15.xlsx

thanks for reply and help

but when i enter data i teachers details sheet it doesn't generates timetable automatically according to given teachers details. plz help

High Regards

 

[Herbds7]

Edited file to accommodate multiple entries in same slot.
Query needs to be refreshed after a detail change.
Same link.

 

[SamT]

Cross posted @ VBA Express
[h=3]generate work schedule[/h]

 

[pipsmultan]

Cross posted @ VBA Express
generate work schedule

Please excuse cross-posting, forgot to post a *link* of ongoing thread