Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Possible Macro or formula

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Possible Macro or formula

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 DataFilterAutofilter 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
D32:D429
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"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.
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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Possible Macro or formula

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)

"Max" wrote:

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 DataFilterAutofilter 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
D32:D429
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"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.
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add a formula to a macro? Aline Excel Discussion (Misc queries) 4 July 24th 08 07:05 PM
Macro with formula orquidea Excel Worksheet Functions 3 December 5th 07 09:53 PM
Formula or Macro M Hebert Excel Discussion (Misc queries) 2 June 27th 07 01:24 PM
Macro and Formula strung Excel Worksheet Functions 3 September 6th 05 02:43 PM
Macro/Formula Help? fluci Excel Discussion (Misc queries) 8 August 5th 05 11:31 PM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"