Just to add: the data which I input should correspond to the date in Col. A

"ash3154" wrote:

I have students which can arrive any day to take an exam, they take approx 45
exams.
Col A32 Date (2/2/2009) goes all the way down till into next year (A429)
Col B32 Day (Monday)
Col C32 "Blank"
Col D Exam number (manual entry via Data Validation)
Col E Grade Recorded (Need to automate)
Col F Date the Grade was recorded (need to automate)

Once they completed their exam, I would input (Somewhere at the top of the
sheet) the following: Date Exam Taken, Grade Received, and Exam number and
click on a button to input that information in the columns listed above.

I hope this makes sense.

Thanks,
Ash