I'm creating a workbook for keeping track of attendance for a rural public school I'm working at in a developing nation. This is excel 2010, and I am a novice at excel. I've tried searching all over the internet but can't figure this out. I have two related things I want to accomplish:
Generating Student Absence Lists
I have four worksheets "freshman", "sophomores", "juniors", and "seniors". Starting at A6, column A lists student names. Starting at B6, column B gives the total number of absences that student has. What I'd like to do is have another worksheet, "principals report" which generates a list of the names of students who have met certain absence thresholds. So there would be 5 lists:
-One for all students who have 2 absences
-One for all students who have 3 absences
-One for all students who have 6 absences
-One for all students who have 9 absences
-One for all students who have 12+ absences
The lists need to spontaneously update as each day the counselor will put in new attendance information and print off the list.
Generating Teacher Submission List
On the same workbook there is another sheet called "Teacher Submission Tracker", where column A (starting at A6) lists teacher names, column B (starting at B6) gives the total number of days that the teacher has failed to turn in their attendance, and column C through HK (starting at C6) is a calendar where each day the counselor puts a "0" if the teacher turns in their attendance, and a "1" if they fail to turn in their attendance. So for instance C6 is for Aug 1st, D6 is for Aug 2nd, and so on. What I'd like (either on the same worksheet as the student absence report or on a new worksheet) is to generate a list that can be printed each day:
A list of the names of each teacher who failed to turn in attendance on a given day. So like check column C from the submission tracker and list any teacher name that has a "1" for the Aug 1st report. Then the next day change it to check column D to generate an Aug 2nd report, then the next day change to column E for the Aug 3rd report... and so on. Its ok if we have to manually change the formula each day from C to D to E or whatever... but hopefully in a way that is very easy to do for someone with essentially zero excel ability and highly limited computer proficiency in general.
I apologize for the long post. I'm novice enough at excel that I don't know how much or how little detail to provide, so I tried to be thorough. I really appreciate any help you could offer. Even just a link to a place where I could figure this out myself would be fantastic... I had a hard time googling around on this issue since I wasn't even sure how to describe what I wanted in a searchable way.
Generating Student Absence Lists
I have four worksheets "freshman", "sophomores", "juniors", and "seniors". Starting at A6, column A lists student names. Starting at B6, column B gives the total number of absences that student has. What I'd like to do is have another worksheet, "principals report" which generates a list of the names of students who have met certain absence thresholds. So there would be 5 lists:
-One for all students who have 2 absences
-One for all students who have 3 absences
-One for all students who have 6 absences
-One for all students who have 9 absences
-One for all students who have 12+ absences
The lists need to spontaneously update as each day the counselor will put in new attendance information and print off the list.
Generating Teacher Submission List
On the same workbook there is another sheet called "Teacher Submission Tracker", where column A (starting at A6) lists teacher names, column B (starting at B6) gives the total number of days that the teacher has failed to turn in their attendance, and column C through HK (starting at C6) is a calendar where each day the counselor puts a "0" if the teacher turns in their attendance, and a "1" if they fail to turn in their attendance. So for instance C6 is for Aug 1st, D6 is for Aug 2nd, and so on. What I'd like (either on the same worksheet as the student absence report or on a new worksheet) is to generate a list that can be printed each day:
A list of the names of each teacher who failed to turn in attendance on a given day. So like check column C from the submission tracker and list any teacher name that has a "1" for the Aug 1st report. Then the next day change it to check column D to generate an Aug 2nd report, then the next day change to column E for the Aug 3rd report... and so on. Its ok if we have to manually change the formula each day from C to D to E or whatever... but hopefully in a way that is very easy to do for someone with essentially zero excel ability and highly limited computer proficiency in general.
I apologize for the long post. I'm novice enough at excel that I don't know how much or how little detail to provide, so I tried to be thorough. I really appreciate any help you could offer. Even just a link to a place where I could figure this out myself would be fantastic... I had a hard time googling around on this issue since I wasn't even sure how to describe what I wanted in a searchable way.