Hi
Looking for a bit of guidance on an issue I have.
As part of my role I have to take export a large marksheet into excel and manipulate the data. This involves breaking down the spreadsheet by gender etc and adding a no of quite exact formulas to a large no of columns.
My issue is this I have to do this half termly and it takes a great deal of time, plus there are a number of opportunities for errors to occur. For example if after manipulating the data I discover an error on the orig marksheet I have to start all over again! ( sometime the errors are not of my making ) So, to speed up/ Automate the operation, bearing in mind the number of students can alter between each data capture period, is there a way I can set up some sort of template in excel ( and I have to do it in Excel as SIMS itself cannot produce the degree of data manipulation required by the SLT), where I could copy varying number of students in but the formulas would remain and the various sorts and gender breakdowns would be done automatically? Am I asking to much of Excel? Would it invole some form of coding? Hve I posted this in the wrong Forum?
Regards
Bhsman
