picking data
 

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
--
Message posted from http://www.ExcelForum.com