Hello I need help with a bit of VBA code.
I need the code to look at Column AI.
Column AI can have a value of 0-7.
If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row.
In the example below row 8 would be deleted as AI = 0, Probed is empty, and so is Notes.
<tbody>
</tbody>
Thank you for any and all help!
I need the code to look at Column AI.
Column AI can have a value of 0-7.
If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row.
In the example below row 8 would be deleted as AI = 0, Probed is empty, and so is Notes.
1 | Date | Probed | Area | Team | AI | Match | Notes | GI |
2 | 9/1/2019 | Team 1 | 7 | |||||
3 | 9/5/2019 | Team 11 | 5 | |||||
4 | 9/7/2019 | Not | Team 3 | 0 | ||||
5 | 9/12/2019 | Team 4 | 4 | |||||
6 | 9/15/2019 | Not | Team 7 | 0 | ||||
7 | 9/22/2019 | Team 9 | 3 | |||||
8 | 9/30/2019 | Team 4 | 0 | |||||
9 | 10/1/2019 | Team 2 | 2 | |||||
10 | 10/02/2019 | Team 6 | 0 | other |
<tbody>
</tbody>
Thank you for any and all help!
Last edited: