Hi

When I say class I mean a different sheet, each class teacher e.g the teacher of grade 8a or grade 8b gets a copy of this sheet into which they type their marks.So in order to eventually get the stats I was asking about , would it not b easier to paste or import all the other sheets into one sheet and then try to write some macro to add up all the different codes per subject