+ Reply to Thread
Results 1 to 2 of 2

Making a home tutor timetable system

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Wales
    MS-Off Ver
    Excel 2012
    Posts
    4

    Making a home tutor timetable system

    Hi all,

    Please, please help. This is actually driving me nuts. I have attached the document below. I want to make a timetable solution for the tuition service i work for. My Excel skills are limited (hence asking this question) but if I can get this spreadsheet to work it would be perfect for our service.

    As an example, when ICT is selected in "Pupil A" on a day/time I want that pupils name to populate one of the four slots for that day/time on "Teacher A (ICT)". Is that possible? Of course, if it works, if Science is selected it will populate another sheet called something like "Teacher F (Science)".

    Of course there will be other pupils/teachers so if the 1st slots filled the pupils name will populate the 2nd, etc. We only teacher small groups of 4 max.

    schedule.xlsx
    Last edited by genieforge; 01-13-2014 at 08:42 PM. Reason: poor wording

  2. #2
    Registered User
    Join Date
    01-13-2014
    Location
    Wales
    MS-Off Ver
    Excel 2012
    Posts
    4

    Re: Making a home tutor timetable system

    I think I;m getting there.

    I got rid of the four boxes for each day in Teacher A (ICT). Now I need to get the timeslots in "Teacher A (ICT)" to look for occurrence of ICT being selected in allthe pupil sheets and return the pupils names into the same cell separated by comma. How would I do that?

    Attached is the amended file.

    schedule.xlsx

+ 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. Need help making my formula system more efficient
    By Yoshi64 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2014, 04:57 PM
  2. Got Cache making Timetable on Spreadsheet
    By k31453 in forum Excel General
    Replies: 2
    Last Post: 02-19-2013, 12:59 AM
  3. making a query for my invoice system in excel
    By colatje in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2011, 05:46 AM
  4. [SOLVED] Making A Databse system on Excel?
    By Lwotton in forum Excel General
    Replies: 2
    Last Post: 01-04-2005, 12:06 PM
  5. MAKING EXCEL AS HOME PAGE IN INTERNET EXPLORER
    By Jagz in forum Excel General
    Replies: 4
    Last Post: 01-02-2005, 11:06 AM

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