pipsmultan
New member
- Joined
- Aug 22, 2014
- Messages
- 10
- Reaction score
- 0
- Points
- 0
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
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