Results 1 to 6 of 6

Thread: generate work schedule

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    generate work schedule

    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
    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Sample Timetable_ v1.jpg 
Views:	534 
Size:	104.1 KB 
ID:	3517  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts