Possible Macro or formula

[ash3154]

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.

 

[Max]

Why not just use autofilter to filter out the date, then just input directly
into the filtered row? Much simpler?

Input appropriate col headers into A31:F31
Select the range A31:F429
Click Data>Filter>Autofilter to apply it
Then for your data entry, just select the date from the autofilter dropdown
in A31, and input as required directly into the filtered row.

You could pre-apply the DV for the exam numbers directly into the range
D32429
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[ash3154]

Yes, that does make sense thou having a macro reduces any error on my part
such as entering the information on an incorrect date.

When the spreadsheet open, I have the date cell as "today()".

I am also thinking about have this information entered by someone say in
workbook1 and having the data in a separate workbook (for privacy reason)