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 Notes, If it is empty delete that Row.
In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no 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 Notes, If it is empty delete that Row.
In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no Notes.
1 | Date | Team | AI | Match | Notes |
2 | 9/1/2019 | Team 04 | 0 | yes | checked |
3 | 9/5/2019 | Team 01 | 4 | yes | |
4 | 9/7/2019 | Team 05 | 0 | no | |
5 | 9/12/2019 | Team 03 | 0 | yes | |
6 | 9/15/2019 | Team 07 | 2 | yes | |
7 | 9/22/2019 | Team 11 | 0 | yes | checked |
8 | 9/30/2019 | Team 09 | 1 | no |
<tbody>
</tbody>
Thank you for any and all help!