Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
input box searching and adding values
Hello, I hope you can help me. I am a teacher and I want to know how I could
automate entering student grades into my spreadsheet. my spreadsheet has the following columns s number surname first name AP401a assess1 AP401a Resit1 AP401a asess2 AP401a resit2 I would like to be able to pick up an exam paper for each subject, have excel ask which subject and then just type in the student number or name and the grade for all of the students in that subject. I would then like the macro to search to see if the student number or name is correct and then enter the result into the spreadsheet. any help would be wonderfully received thanks Paul. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
input box searching and adding values
G'day Paul
I have had a bit of a play around with an idea which may suit your needs. If you like the layout, simply modify the details section to your specifications and enjoy. Drop me a line @ I will send you the file. HTH Regards Mark. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
input box searching and adding values
G'day Paul
Got your e-mail, but there is no return address for it, just displays "XX_XX". You will need to send me your e-mail address so I can forward the file to you. Regards Mark. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching cells from user input | Excel Discussion (Misc queries) | |||
Searching and adding in a closed file | Excel Programming | |||
Searching and adding a value. | Excel Worksheet Functions | |||
Searching data in a column via Input Box | New Users to Excel | |||
Adding input box number to range of cells values | Excel Programming |