Hello DJ:
I will begin by showing how to get just what you want for the first student.
The problem lies in transferring data that is stored horizontally into a
vertical form.
1) On sheet P1 Student Summary, select A19:A36
2) type the formula =TRANSPOSE(Period1!E2:V2) commit this with
CTRL+SHIFT+ENTER (CSE) as it is an array formula. Since; it has been array
entered, it will display in the formula bar as
{=TRANSPOSE(Period1!E2:V2)}
The result is not very interesting but move along
4) select B19:B19, type =TRANSPOSE(Period1!E3:V3); use CSE to enter; and you
get
HW
HW
HW
CW
CW
T
Q etc
5) select C19:C19, type =TRANSPOSE(Period1!E5:V5); use CSE to enter; and you
get
12
24
25
12
15
0 etc
6) I think you can see how to get the D column
It is going to be sheer murder doing this for 25+ students on several
sheets.
As a chemistry prof, I kept electronic grade date since 1968 (first on a
main frame, then on a PC with Lotus123 and then with Excel.) I also wrote a
university student information system. So please let me be bold enough to
make suggestions.
1) We need to get rid of the horizontal to vertical problem. I think the
Period1 sheet can be 'rotated' so that we can more readily take date to
another sheet.
2) It would seem the summary sheets are needed only to print off reports.
Why not design one that processes just one student. Then with some simple
VBA we can cycle through the list of students, printing one for each.
Let's continue this at a personal level - just remove TRUENORTH. from my
email address
best wishes
