I have a workbook that has about 250 rows of student information. The columns are as follows:

LastName
FirstName
StudentId
SpringHours
FallHours

The column I am interested in is the FallHours. Right now our data clerk has to input hours that students have made up. So she has to use the Find field, type in the StudentID and then input the hours in that students cell. If there are already hours in that cell she then has to total the hours she is inputting.

Is there any coding where the data clerk could just type in the StudentID and the Fallhours on a seperate worksheet. Then have the coding check the master document by StudentID and when it finds a match, it will input the new hours and total the hours if that cell already had a number in it? It sure would save us hours of manual labor. Thank you, hope someone can help.