Is it possible to create VBA to scoll through a table of data, example below (actual table is 39k rows long), and where the reason (differential Reason 1 & 2) equals 'Let Property' to remove the differential rate from the differential's 1 and/or 2, total differential and Final rate columns.
Line 1 would change in the table to
Total Differential = null/blank
Differential 1 = null/blank
Final Rate = 2.25, line 2 would be unafected as no let property reason shown
<TBODY>
</TBODY>
Line 1 would change in the table to
Total Differential = null/blank
Differential 1 = null/blank
Final Rate = 2.25, line 2 would be unafected as no let property reason shown
Total Differential | Differential 1 | Differential Reason 1 | Differential 2 | Differential Reason 2 | Final Rate |
1.00 | 1.00 | Let Property | 3.25 | ||
1.25 | 1.25 | Other | 1.75 | ||
2.49 | 1.99 | Other | 0.50 | Let Property | 2.99 |
1.75 | 0.50 | Let Property | 1.25 | Other | 2.25 |
1.99 | 1.99 | Other | 4.99 | ||
1.00 | 1.00 | Let Property | 3.50 | ||
2.00 | 1.25 | Other | 0.75 | Other | 2.50 |
1.99 | 1.99 | Other | 4.49 | ||
0.50 | 0.50 | Let Property | 2.75 |
<TBODY>
</TBODY>