J
jimteacher
Hi!
I'm a teacher at a high school with 1800 students.
The attendance lady types up an excel file each day
listing the tardies and early outs, etc. for each student
who comes in on that day for a pass.
This would end up as 180 excel files a year.
She would like to be able to search for a particular
student's name throughout all files to generate a
report which would tell her how many early outs, etc.
(stuff that isn't in the regular absence report scanned
in once a day) that one particular student
has had. Now she has to do this manually, looking
through paper files for each student.
Can one search be done through multiple files with
a macro?
Or can all this info be transferred each day to another
excel file (combining the info into one file), cumulatively,
or can it be put into an access file so that it can be
queried?
She isn't into complexities, so it has to be pretty easy,
which is why come kind of a macro would help.
Thanks for any help you can give us, as it's a royal
pain to go though hundreds of paper files.
Jimteacher
I'm a teacher at a high school with 1800 students.
The attendance lady types up an excel file each day
listing the tardies and early outs, etc. for each student
who comes in on that day for a pass.
This would end up as 180 excel files a year.
She would like to be able to search for a particular
student's name throughout all files to generate a
report which would tell her how many early outs, etc.
(stuff that isn't in the regular absence report scanned
in once a day) that one particular student
has had. Now she has to do this manually, looking
through paper files for each student.
Can one search be done through multiple files with
a macro?
Or can all this info be transferred each day to another
excel file (combining the info into one file), cumulatively,
or can it be put into an access file so that it can be
queried?
She isn't into complexities, so it has to be pretty easy,
which is why come kind of a macro would help.
Thanks for any help you can give us, as it's a royal
pain to go though hundreds of paper files.
Jimteacher