Hi folks,
I have a table to track Personal, sick, vacation and half days taken for 25 to 150 students.
They are recorded by placing an "S", "P", "V", or an "H" in the cells for the corresponding date.
There is a different tab for each month.
School year July 1 2016 to June 30 2017.
I would like some code to pull the dates for all category entries, for each month, then place them in a table within each students reporting tab and sorted by date.
Below is a partial July 2016 table.
<colgroup><col><col span="31"></colgroup><tbody>
</tbody>
I have a table to track Personal, sick, vacation and half days taken for 25 to 150 students.
They are recorded by placing an "S", "P", "V", or an "H" in the cells for the corresponding date.
There is a different tab for each month.
School year July 1 2016 to June 30 2017.
I would like some code to pull the dates for all category entries, for each month, then place them in a table within each students reporting tab and sorted by date.
Below is a partial July 2016 table.
July | Dates of Absence | ||||||||||||||||||||||||||||||
Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
Student Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
Student 1 | |||||||||||||||||||||||||||||||
Student 2 | |||||||||||||||||||||||||||||||
Student 3 | |||||||||||||||||||||||||||||||
Student 4 | |||||||||||||||||||||||||||||||
Student 5 | |||||||||||||||||||||||||||||||
Student 6 | |||||||||||||||||||||||||||||||
Student 7 | |||||||||||||||||||||||||||||||
Student 8 | |||||||||||||||||||||||||||||||
Student 9 | |||||||||||||||||||||||||||||||
Student 10 | |||||||||||||||||||||||||||||||
Student 11 | |||||||||||||||||||||||||||||||
Student 12 | |||||||||||||||||||||||||||||||
Student 13 Is anyone able to help with this? Vince |
<colgroup><col><col span="31"></colgroup><tbody>
</tbody>