The code I wrote put all the info you would need to put into a userform
on one row of sheet 3. Then all you have to do is located the sudent
row that you are looking for and take the data starting in column 5.

If you have the dat like you shown in multiple rows then the code is
simply some thing like this



if Range("A1") < "" then
textbox1 = Range("A1")
if Range("A2") < "" then
textbox2 = Range("A2")
if Range("A3") < "" then
textbox3 = Range("A3")
end if
end if
end if


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=175357

Microsoft Office Help