Excel _ Data Input Help

[capt_pak]

alrite heres the situation -
my boss just dropped about 600 sheets of paper on my desk ... these "papers" are student records from the educational institute i work at... she wants me to extract the following from the paper and manually input it all into excel "Student Name" "Student ID" "Date" "Class Code" "Institutional" "Time (Minutes)"

- it'll prolly take me a good 2-3 hours going thru the whole pile but i am sure there is a way of designing some type of database where once i start entering the info it can autofill the rest of the field. i also want to create a simple interface so that others at work can work into a web page based input system rather than excel itself? my boss later wants to generate reports from the entered data...

can someone point me in the right direction please other than a new job ? lol

thanks in advance

[redbeard]

Have you considered using the lookup feature in Excel? It wouldn't be as sophisticated as a formal database, but should get you running more quickly and then you can design a more elegant solution if needed with a DB down the road.