First, a quick "Thank You!" from myself and others in my department at the
school. I've progressed quite a bit with VBA, and a lot of that is because of
those of you who have helped me here. I'm still a novice, though, so I hope I
explain this conundrum well:

I have set up a gradebook and written a macro in workbook "SG GB S2009".
This macro opens up "AccelTest Results.csv", which is updated before the
macro runs. This update includes changing previous scores (when students
retake quizzes, for example).

The macro takes the information from Column B (a quiz title in Row 1, then
the individual scores starting in Row 4), then searches "SG GB S2009" for the
first unused column, and then pastes that information.

The macro then loops, so that in "AccelTest Results", it moves over to
Column C, copies, then searches "SG GB S2009" for the next open column,
pastes. And then again, until all quizzes have been entered.

This is all well and good for a one time run, but I would like to write a
code such that when the macro looks in "AccelTest Results" and gets the quiz
title and scores, it searches Row 7 in "SG GB S2009" (which has the titles of
each assignment" and tries to match the quiz title to an assignment title. If
it does, it stops, and pastes the scores over the previous scores, thereby
updating the gradebook. If it cannot match a title, it continues as it
normally would, looking for the next empty column.

The second question:

I also cannot figure out how to get the macro to search a specific column or
row for a name, then when it finds it, look in another row or cell, a
specified distance away, and get or enter information (depending on what I'm
doing).

I have learned to use the "If... Then... Else..." and "Do While" and "Do
While Not" statements, and I think I know how to use "With". But I cannot
figure out how to get the macro to look for a specific name.

Thanks!