A
axg275
Hello guys,
Thanks for looking and trying to help
I have a work book consisting of five sheets. Each sheet contain
student names (in column A) in my class, their email address (Colum
B). Columns C through J or H or F depending on the sheet in this wor
book contain students exam response with the grade they were given b
TA. It look something like this
A B C D
F ........
Student Email Q # 10 Grade Q#10 Q#30 Grade #30
Name
----------------------------------------------------------------------------------
Bob Bob@ Good day 45 Not so
90
Nancy Nancy@ Very good 0 Good
70
Notice that questions do not come in order, and there are 5 sheets lik
this in my workbook.
My task it try to construct a macro which would create a new sheet cop
all the students names into it then go through all the sheets in thi
work book and pick grades for each Q# and place it in the newly create
sheet in the right place next to the right student.
My problem with doing this is that I don’t know how to make it look i
a specific column without using offset function and I don’t know how t
go about not knowing how many columns in each worksheet.
I am attaching a scrren shoot of the spread sheet I have.
Please help me out if you have any clue on how to go about this.
Greatly Appreciate
Attachment filename: workbook.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=64175
Thanks for looking and trying to help
I have a work book consisting of five sheets. Each sheet contain
student names (in column A) in my class, their email address (Colum
B). Columns C through J or H or F depending on the sheet in this wor
book contain students exam response with the grade they were given b
TA. It look something like this
A B C D
F ........
Student Email Q # 10 Grade Q#10 Q#30 Grade #30
Name
----------------------------------------------------------------------------------
Bob Bob@ Good day 45 Not so
90
Nancy Nancy@ Very good 0 Good
70
Notice that questions do not come in order, and there are 5 sheets lik
this in my workbook.
My task it try to construct a macro which would create a new sheet cop
all the students names into it then go through all the sheets in thi
work book and pick grades for each Q# and place it in the newly create
sheet in the right place next to the right student.
My problem with doing this is that I don’t know how to make it look i
a specific column without using offset function and I don’t know how t
go about not knowing how many columns in each worksheet.
I am attaching a scrren shoot of the spread sheet I have.
Please help me out if you have any clue on how to go about this.
Greatly Appreciate
Attachment filename: workbook.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=64175