+ Reply to Thread
Results 1 to 11 of 11

Extracting data from school timetable

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Extracting data from school timetable

    Hi everyone. I have a school time table (2 weeks) which I need to be able to extract the information for certain faculties from to create a smaller worksheet that has all the classes for that department. ie. be able to pull all the maths classes from the entire timetable, or all the english classes. Is there a way to say 'i need to just list/bold/colour/copy to a new spreadsheet all the classes that have *ma* or *en* in them?

    I need to extract the information from the 'just classes' tab or the 'mastersheet' - just classes doesn't have teh additional ifnormation of the classrooms which we don't really need.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,328

    Re: Extracting data from school timetable

    You are using the old Excel 2010 - is this correct?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Extracting data from school timetable

    In sheet 'JustClasses' A1:A3 Clear/MAT/ENG Click on each CLEAR also puts a copy onto Sheet2, then if MAT or ENG are clicked on. this highlights relative cells and places copy on Sheet2.
    I have removed merged cells as they make the copy unstable, if you reinstate them the process will fail.
    torachan.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-19-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Extracting data from school timetable

    Thankyou torachan that is awesome! Can you tell me how you did it? Can I now add other subjects?

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Extracting data from school timetable

    Macro on Worksheet_SelectionChange Event.
    You could change the enteries in A2 or A3 or make additions elsewhere and add another "If Not Intersect(Target, Range("????")) Is Nothing Then" statement.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-19-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Extracting data from school timetable

    Wow...I have absolutely no idea what that all is ha ha. That's amazing. I'm not sure I will be able to work out how to do it but I will have ago. Can you point me in the direction of where you actually enter this in?

  7. #7
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Extracting data from school timetable

    Right mouse click on 'Just Classes' tab - in small pop-up menu 'View Code' - this is the code in that sheet module - similar to a macro but in specific to one sheet.
    torachan.

  8. #8
    Registered User
    Join Date
    01-19-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Extracting data from school timetable

    Hi Torachan - as you can probably guess I am very new at all of this!!! I'm not very good at excel at all other than just entering data.

    Ok, so I have tried to add a third line/statement as you suggested ( I will need to be able to pick up to 4 different elements/years - so like 7mat, 8mat, 9mat and 10 mat (junior school) at all once, so 4 statements would be excellent. Anyway, the one I did I put it in b2, but it didn't seem to work in that if I put 9mat, it kept highlighting 8mat classes. Is there a way to add 2 more rows below a3 to be able to add these?

    Also, in the grades there will be a 7amat, 7bmat, 7cmat etc...so is possible to make it search for all 7?mat classes by using 7*mat as the search term?

    I've attached my workbook with what I have attempted to do!! (Don't laugh too much). As I said, I have never used excel for much other than data entry so this is a huge steep learning curve!

    Thanks again for all your help If I'm being too annoying or a pain please don't feel obligated to help out - I will totally understand!!
    Celesty

  9. #9
    Registered User
    Join Date
    01-19-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Extracting data from school timetable

    Arrgghh I can't attach anything!

  10. #10
    Registered User
    Join Date
    01-19-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Re: Extracting data from school timetable

    I think i've attached it now Maybe
    Attached Files Attached Files

  11. #11
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Extracting data from school timetable

    Give this a try - small green button - upper left cell - launches small form - gives maximum four choices - just type in textboxes & press choose
    Attached Files Attached Files

+ 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. School College University Timetable Planner Help Please ??
    By teachinginedinburgh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2020, 08:29 PM
  2. Summarized data based on timetable sequence
    By aligahk06 in forum Excel General
    Replies: 1
    Last Post: 07-31-2019, 11:23 AM
  3. How to transfer data from the 'Logbook' into a 'Timetable'
    By vkosov in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2018, 10:10 AM
  4. Rearranging timetable data
    By tessda in forum Excel General
    Replies: 1
    Last Post: 04-22-2016, 10:04 PM
  5. Extracting Data From Chart (Railroad Timetable)
    By willbacker45 in forum Excel General
    Replies: 5
    Last Post: 03-07-2016, 09:32 AM
  6. school timetable
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2013, 01:05 AM
  7. distribute Periods in a school timetable
    By TOTO_POP in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-01-2010, 05:06 PM

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