Results 1 to 6 of 6

Thread: generate work schedule

  1. #1

    generate work schedule



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:	526 
Size:	104.1 KB 
ID:	3517  

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

  3. #3
    Quote Originally Posted by Herbds7 View Post
    Excel 2010 with free Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    No formulas, no VBA macro.
    http://www.mediafire.com/view/wjcc1p.../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

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

  5. #5
    Cross posted @ VBA Express
    generate work schedule


  6. #6
    Quote Originally Posted by SamT View Post
    Cross posted @ VBA Express
    generate work schedule
    Please excuse cross-posting, forgot to post a *link* of ongoing thread

Posting Permissions

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