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.
The data which I input should correspond to the date in Col. A

Ex: if i type in today's date A1, B1, C1 as 2/9/09, Grade A, exam # 345
I want the formula to search for the date in Column A, and input the
information in its respective columns.
Next time they come in to take an exam, I would like to type in A1, B1, C1
the new information and so on.


I hope this makes sense.