+ Reply to Thread
Results 1 to 12 of 12

Creating a Teacher Schedule With Lists of Students based on student schedules

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Creating a Teacher Schedule With Lists of Students based on student schedules

    I am trying to create a program that I can used to build student schedules on that will automatically give me names of students in each of a teacher's classes. For example, I can build a schedule for John Smith. John Smith is in Math 1st period, Science 2nd, History 3rd, etc. I want to have a separate sheet for each teacher, and based upon the main sheet of students, each student would show up in each class. I have already built the program for the most part, with the first student in that class's name. The problem I am having is retrieving the rest of the names on the list.

    I will attach my file in-case there is anyone out there who wants to take a stab at it.

    2015-2016 High School Schedule.xlsx

    Much appreciated!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Can you include a sample workbook WITH data I can see flowing through the model?
    I dont see the teachers names, or how you identify who goes where... but I would suspect you can do ALL of this with a pivot table (AND NO FORMULAS!) since your Students tab is standardized (except for the crazy freshman-senior column lol).

    Post a sample workbook that includes FAKE data and a fake example or two of the reports you are trying to create. Make sure it has all the data in it, like names, class, teacher name or whatever you want to have so its a CLEAR representation of what you are trying to accomplish and I bet I can help you with a simple solution.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    EDIT: double post, somehow

  4. #4
    Registered User
    Join Date
    01-10-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Sorry not to respond in so long! The teachers names are the sheet names. Just to clarify,you want me to fill in a sample schedule for a few students and, instead of putting the formula I want in the cell on the teachers sheet, fill in the students' names that SHOULD show up according to the formula I eventually want?

  5. #5
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Correct.

    Sample Data and sample proposed solution.

  6. #6
    Registered User
    Join Date
    01-10-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Sample HS Schedule.xlsx

    I added 4 schedules, and typed in names as the second line on the teachers' rosters. I left the first line as the formula since it already works.

    Thank you so much for your help!

  7. #7
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    you dont have a list of teachers in the main data, so I have no idea who goes where or why.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    I've looked at this a few times.... and FINALLY, I understand what you're after.... I shared MikeTron's confusion.

    One thing. Do you want the search to go to the bottom of the list (i.e. row 309) or just to the bottom of the freshmen. I've set it only for freshmen. If that's wrong, simpluy adjust the ranges. I've only done this for two teachers (Davis & J. Hill). I daresay you can do the rest.

    Drag the formula right & down.

    Any problems, shout...
    Attached Files Attached Files
    Glenn



  9. #9
    Registered User
    Join Date
    01-10-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Sorry for the confusion! mikeTRON, The teacher's names are the titles of the other sheets. Thank you so much for the Formula Mr. Kennedy!

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

  11. #11
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    Quote Originally Posted by ked2313 View Post
    Sorry for the confusion! mikeTRON, The teacher's names are the titles of the other sheets. Thank you so much for the Formula Mr. Kennedy!
    Yeah, my intention was to get them all in simple data, and then use a vlookup or powerpivot to marry the two datasets together, so then EVERYTHING is a pivot table

  12. #12
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Creating a Teacher Schedule With Lists of Students based on student schedules

    It took me a while to realise that the teacher's names weren't important. The class names define/are unique to the teacher (I hope.... or I've given the wrong solution).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using VBA to cross-reference class & teacher schedules
    By eureka987 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-16-2015, 03:38 PM
  2. [SOLVED] Creating Individualised Schedules from Class Lists
    By ashleyd in forum Excel General
    Replies: 2
    Last Post: 07-06-2012, 06:26 PM
  3. [SOLVED] Why can't I use XML in the Student and Teacher Edition?
    By gunnyusmcret in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-26-2006, 04:30 PM
  4. Why can't I use XML in the Student and Teacher Edition?
    By gunnyusmcret in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2006, 02:00 PM
  5. [SOLVED] Why can't I use XML in the Student and Teacher Edition?
    By gunnyusmcret in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2006, 12:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1