I'm new to VBA ... so feel somewhat dumb. Anyhow, I'm a school counsellor and am building an Excel spreadsheet for our local scholarship association meeting. I have exported a tab delimited file from our school admin. software and have put it into an Excel worksheet named "data_sheet" with one row per student and columns: Surname, Given Name, Student Number, and sutdent grades labeled Course 1, Mark 1; Course 2, Mark 2; to Course 20, Mark 20).
I have laid out another "personal worksheet" that performs calculations on the data from the "data" sheet, and allows for the input of volunteer hours, parental affiliations, etc. I need one of these sheets for each student. I also set up a range of cells in this new worksheet (a column with the course and another for the grade) to perform calculations on the students courses and grades according to the scholarship rules (that part is easy). I want the course and grade information for each student to be entered into the appropriate columns in that range of cells, and for only those cells to be sorted in descending order by grade.
What I am looking for is a script that will duplicate the "personal worksheet" for each student, name the worksheet, place the course & grade information in the appropriate cells in the range, and sort. Have spent two days on the problem and haven't got anywhere.
Any help greatly appreciated.