Transpose in Macro

[Salza]

Hello everyone ...

I am preparing an exam marksheet for a class of 50 students.
I am using 16 columns for "marks" and another 16 columns for "grade".
Then, a few more columns for "total", "percentage""position in class",
"attendance", "behavior" etc.

On another worksheet, I want to prepare an individual report card for each
student where teacher can simply typo the name of a student in one cell,
then all the marks, grade etc will appear automatically in that report
card..

I tried to use "transpose" to transfer the marks using a macro BUT still
can not get things in order ...
Can someone help me ... let me know so that I can send you my marksheet
....(part of it).
Please help me to rectify the mistake in that marksheet.

Please help ......


Thank you,

Salza.

 

[Ron de Bruin]

Hi Salza

Look in the Excel help for the VLookup and HLookup functies

You can use this formula for example to a cell in the report sheet whith
the name of the student(lookup value) in a1
It will search for the name in a1:a1000 in the marksheet and show the value
in the second column

=VLOOKUP(A1,marksheet!A1:L1000,2)

Post back if you need help

 

[Alan Beban]

And =VLOOKUP(A1,marksheet!A1:L100,{2,3,4},FALSE), array entered into a
3-column row, will return the values from the 2nd, 3rd and 4th columns.

Alan Beban