VBA Sum & Combine Data

[Stephen_IV]

Good morning I have a large data set approx 100,000 rows.
I need to sum and combine the data based on Emp ID and DEPT only if they are the same.
If the Emp ID and DEPT are not the same then leave it be.
There will always be a Cur or Re in Column (S)
The data must be Combined and summed in Cur. Cur stands for current!
<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>Emp ID</th><th>LASTFIRST</th><th>SCORE</th><th>DEPT</th><th>AUGMEM</th><th>AUGATT</th><th>SEPMEM</th><th>SEPATT</th><th>OCTMEM</th><th>OCTATT</th><th>Cur or Re</th></tr></thead><tbody>
<tr><td>8043998</td><td>wwwww</td><td>10</td><td>A</td><td>0</td><td>0</td><td>0</td><td>0</td><td>1</td><td>1</td><td>Cur</td></tr>
<tr><td>8043998</td><td>wwwww</td><td>10</td><td>A</td><td>0</td><td>0</td><td>19</td><td>5</td><td>0</td><td>0</td><td>Re</td></tr>
<tr><td>8043998</td><td>wwwww</td><td>10</td><td>A</td><td>1</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>Re</td></tr>
<tr><td>9998876</td><td>xxxxxxxx</td><td>11</td><td>B</td><td>1</td><td>0</td><td>19</td><td>0</td><td>21</td><td>0</td><td>Cur</td></tr>
<tr><td>8052141</td><td>yyyyyyyy</td><td>10</td><td>C</td><td>0</td><td>0</td><td>8</td><td>0</td><td>3</td><td>0</td><td>Cur</td></tr>
<tr><td>8052141</td><td>yyyyyyyy</td><td>10</td><td>C</td><td>1</td><td>1</td><td>5</td><td>3</td><td>0</td><td>0</td><td>Re</td></tr>
<tr><td>7765432</td><td>zzzzzzzzz</td><td>9</td><td>D</td><td>0</td><td>0</td><td>0</td><td>0</td><td>21</td><td>5</td><td>Cur</td></tr>
<tr><td>7765432</td><td>aaaaaaa</td><td>9</td><td>E</td><td>1</td><td>1</td><td>19</td><td>0</td><td>0</td><td>0</td><td>Re</td></tr>
</tbody></table>

To this
<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>Emp ID</th><th>LASTFIRST</th><th>SCORE</th><th>DEPT</th><th>AUGMEM</th><th>AUGATT</th><th>SEPMEM</th><th>SEPATT</th><th>OCTMEM</th><th>OCTATT</th><th>Cur or Re</th></tr></thead><tbody>
<tr><td>8043998</td><td>wwwww</td><td>10</td><td>A</td><td>1</td><td>0</td><td>19</td><td>5</td><td>1</td><td>1</td><td>Cur</td></tr>
<tr><td>9998876</td><td>xxxxxxxx</td><td>11</td><td>B</td><td>1</td><td>0</td><td>19</td><td>0</td><td>21</td><td>0</td><td>Cur</td></tr>
<tr><td>8052141</td><td>yyyyyyyy</td><td>10</td><td>C</td><td>1</td><td>1</td><td>13</td><td>3</td><td>3</td><td>0</td><td>Cur</td></tr>
<tr><td>7765432</td><td>zzzzzzzzz</td><td>9</td><td>D</td><td>0</td><td>0</td><td>0</td><td>0</td><td>21</td><td>5</td><td>Cur</td></tr>
<tr><td>7765432</td><td>aaaaaaa</td><td>9</td><td>E</td><td>1</td><td>1</td><td>19</td><td>0</td><td>0</td><td>0</td><td>Re</td></tr>
</tbody></table>