If you want to send me a copy of the workbook with two or three rows of data
in the data sheet and the personal worksheet "template" sheet, I will
provide some code to do what you want.



It is hard to provide anything here since nothing is known about the
personal worksheet as far as specific locations an layout.

--
Regards,
Tom Ogilvy

"doc_in_bc " wrote in message
...
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 a "data sheet"
with one row per student: Surname, Given Name, Student Number, and
their grades (Course 1, Mark 1; Course 2, Mark 2 ... 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 in this new worksheet to
perform calculations on the students 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 the script, and to be sorted in descending order of 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.
Doug


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