Transpose in Macro

  • Thread starter Thread starter Salza
  • Start date Start date
S

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.
 
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
 
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
 
Back
Top