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.
Bookmarks