jayploc
09-30-2008, 08:24 AM
Hello,
I've posted a few questions similar to this, but this one is slightly different and I cannot figure it out.
I have a workbook with 2 sheets. Sheet 1 has 3 seperate sections for a biology class, sorted by last name and containing a blank column for "Exam 1". In sheet 2 is a list of all of biology test scores containing ALL of the students in one list.
I want to match them by last/first name and fill in the Test 1 score in the 3 columns marked for it in sheet 1.
If anyone can help me with a code I would appreciate it.
Thanks.
I've posted a few questions similar to this, but this one is slightly different and I cannot figure it out.
I have a workbook with 2 sheets. Sheet 1 has 3 seperate sections for a biology class, sorted by last name and containing a blank column for "Exam 1". In sheet 2 is a list of all of biology test scores containing ALL of the students in one list.
I want to match them by last/first name and fill in the Test 1 score in the 3 columns marked for it in sheet 1.
If anyone can help me with a code I would appreciate it.
Thanks.