I'm new to VBA ... so feel somewhat dumb. Anyhow, I'm a schoo
counsellor and am building an Excel spreadsheet for our loca
scholarship association meeting. I have exported a tab delimited fil
from our school admin. software and have put it into a "data sheet
with one row per student: Surname, Given Name, Student Number, an
their grades (Course 1, Mark 1; Course 2, Mark 2 ... Course 20, Mar
20).

I have laid out another "personal worksheet" that performs calculation
on the data from the "data" sheet, and allows for the input o
volunteer hours, parental affiliations, etc. I need one of these sheet
for each student. I also set up a range in this new worksheet t
perform calculations on the students grades according to th
scholarship rules (that part is easy). I want the course and grad
information for each student to be entered into the appropriate column
in the script, and to be sorted in descending order of grade.

What I am looking for is a script that will duplicate the "persona
worksheet" for each student, name the worksheet, place the course
grade information in the appropriate cells in the range, and sort. Hav
spent two days on the problem and haven't got anywhere.

Any help greatly appreciated.
Dou

--
Message posted from http://www.ExcelForum.com