Help please

%3CLINGO-SUB%20id%3D%22lingo-sub-1655926%22%20slang%3D%22en-US%22%3EHelp%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655926%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20create%20a%20database%20with%20student%20last%20name%2C%20first%20name%2C%20grade%20and%20group%20(either%20a%20b%20or%20c).%20From%20my%20data%2C%20I%20would%20like%20all%20students%20(last%2C%20first%20name%20and%20grade)%20in%20each%20group%20be%20sorted%20in%20another%20worksheet%20(one%20for%20a%2C%20one%20for%20b%20and%20one%20for%20c).%20However%2C%20the%20group%20letter%20can%20change%20so%20wondering%20how%20I%20can%20have%20the%20groups%20change%20too.%3CBR%20%2F%3E2nd%20goal%20is%20once%20sorted%20in%20a%2C%20b%20and%20c%20groups%2C%20I%20would%20like%20to%20assign%20each%20student%206%20different%20class%20periods%20by%20teacher%20last%20name%2C%20and%20based%20on%20that%20data%2C%20would%20like%20to%20have%20a%20master%20list%20of%20each%20period%2C%20where%20each%20teacher%20(15%20total)%20will%20have%20a%20column%20with%20all%20students%20in%20their%20class%20for%20that%20hour.%20Again%2C%20the%20classes%20may%20change%20so%20would%20need%20to%20be%20able%20to%20easily%20refreash.%3CBR%20%2F%3EIs%20this%20even%20possible%3F%3CBR%20%2F%3EThanks%20for%20any%20help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1655926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1656706%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1656706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F789887%22%20target%3D%22_blank%22%3E%40Jmiz21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20a%20template%20as%20you%20asked%3C%2FP%3E%3CP%3Eyou%20need%20to%20press%20F9%20after%20any%20change%20as%20I%20used%20recursive%20formulas%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20it%20is%20fine%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am trying to create a database with student last name, first name, grade and group (either a b or c). From my data, I would like all students (last, first name and grade) in each group be sorted in another worksheet (one for a, one for b and one for c). However, the group letter can change so wondering how I can have the groups change too.
2nd goal is once sorted in a, b and c groups, I would like to assign each student 6 different class periods by teacher last name, and based on that data, would like to have a master list of each period, where each teacher (15 total) will have a column with all students in their class for that hour. Again, the classes may change so would need to be able to easily refreash.
Is this even possible?
Thanks for any help
1 Reply

@Jmiz21 

Please find a template as you asked

you need to press F9 after any change as I used recursive formulas

 

hope it is fine