Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,177
- Office Version
- 365
- 2019
- Platform
- Windows
Good afternoon,
I have a sample data set below.I have over 500,000 records. Each child can have from 1 to 182 days absent (1 to 182 lines of data). What I need to do is to have VBA list on Sheet2 every 10th school or 10th line per Id number and if the child does not have 10 absences then bring back 0. Thanks in advance!
For the sample below:
11111 10th line is 102
22222 10th line is 114
Thanks in advance
<style type="text/css">
table.tableizer-table {
font-size: 8px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>ID</th><th>School</th><th>Date</th><th>DESCRIPTION</th></tr></thead><tbody>
<tr><td>11111</td><td>100</td><td>9/1/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/2/2016</td><td>Unexcused Absence</td></tr>
<tr><td>11111</td><td>100</td><td>9/5/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/6/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/7/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/8/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/9/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/12/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/13/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>102</td><td>9/14/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>102</td><td>9/15/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>103</td><td>9/16/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>103</td><td>9/19/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/20/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/21/2016</td><td>Unexcused Absence</td></tr>
<tr><td>22222</td><td>102</td><td>9/22/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/23/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/26/2016</td><td>Unexcused Absence</td></tr>
<tr><td>22222</td><td>102</td><td>9/27/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/28/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/29/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/30/2016</td><td>Unexcused Absence</td></tr>
<tr><td>22222</td><td>114</td><td>10/3/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>114</td><td>10/4/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>116</td><td>10/5/2016</td><td>Unexcused Absence</td></tr>
</tbody></table>
I have a sample data set below.I have over 500,000 records. Each child can have from 1 to 182 days absent (1 to 182 lines of data). What I need to do is to have VBA list on Sheet2 every 10th school or 10th line per Id number and if the child does not have 10 absences then bring back 0. Thanks in advance!
For the sample below:
11111 10th line is 102
22222 10th line is 114
Thanks in advance
<style type="text/css">
table.tableizer-table {
font-size: 8px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>ID</th><th>School</th><th>Date</th><th>DESCRIPTION</th></tr></thead><tbody>
<tr><td>11111</td><td>100</td><td>9/1/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/2/2016</td><td>Unexcused Absence</td></tr>
<tr><td>11111</td><td>100</td><td>9/5/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/6/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/7/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/8/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/9/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/12/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>100</td><td>9/13/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>102</td><td>9/14/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>102</td><td>9/15/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>103</td><td>9/16/2016</td><td>Absent</td></tr>
<tr><td>11111</td><td>103</td><td>9/19/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/20/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/21/2016</td><td>Unexcused Absence</td></tr>
<tr><td>22222</td><td>102</td><td>9/22/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/23/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/26/2016</td><td>Unexcused Absence</td></tr>
<tr><td>22222</td><td>102</td><td>9/27/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/28/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/29/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>102</td><td>9/30/2016</td><td>Unexcused Absence</td></tr>
<tr><td>22222</td><td>114</td><td>10/3/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>114</td><td>10/4/2016</td><td>Absent</td></tr>
<tr><td>22222</td><td>116</td><td>10/5/2016</td><td>Unexcused Absence</td></tr>
</tbody></table>
