If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Micros or paste special(link) again
It seems my good pals did not get me well. the student report is not
to be 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 WK, 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 for each subject, the individual student report will automatically be ready for printing). sorry for making my problem cumbersome. THANKS. |
#2
|
|||
|
|||
Micros or paste special(link) again
As you want a printed copy so what you need to do is to fill the data and
print it. I guess the easiest way with least programming is that you create a template report and use each row of data (let say it is a sheet called 'data'), then you insert a colume to identify each row, e.g. student ID. Then you create another tab called 'report', then each field (which will be change to each student), use Vlookup formula to lookup each item of score. So when you change the student ID cell on the report tab, the data will be changed accordingly. once you have made that up then you can either manually type each student ID and click print, which i think quite quick. Or you create a macro. But it require some programming knowledge and skill. such macro do the same thing that put each number in the student ID then print it. " wrote: It seems my good pals did not get me well. the student report is not to be 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 WK, 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 for each subject, the individual student report will automatically be ready for printing). sorry for making my problem cumbersome. THANKS. . |
Thread Tools | |
Display Modes | |
|
|