Micros or paste special(link) II

I should have added that the earlier post was to be automatic. ie
after filling the students score sheet eor the class the individual
report will be filled automaticaly.

On Dec 30, 2:36*pm, wrote:
I should have added that the earlier post was to be automatic. ie
after filling the students score sheet for the class the individual
report will be filled automaticaly.

it seems my good pals did not get me well. the student report is to
sent thru the E-mail.
What I want is something that will automatically generate a student
report for each student in the class
Eg for a class of 40 students, there will 8 sujects for each student
to take part. I have already prepared a spreadsheet for that- with
these headings; NAME, PROJECT, HOMEWORK, EXAMS, TOTAL, POSITION IN
SUBJECT, GRADE, REMARKS (so I have 8 similar worksheets like this for
each subject). What I need is an automatic means for filling in the
students report(ie after filling the general score for the class the
individual student report will automatically be ready for printing).
sorry for making my problem cumbersome. THANKS.