Hello. I need to find the cells in column A that has the word Total in it, and if that row has the word Total in it it will replace the value of column C with 1. Here's my sample table:
<tbody>
</tbody>
As you can see, the cells in column C with the word Total in column A are zero. The zeroes must be replaced by 1. I am totally in the dark on how to replace it using the word Total. I'm still grasping the basics of vba and I need to do it using vba only. I've been searching for a code that will fit my need but no luck. Any suggestion will be appreciated. Thank you!
Team | Purchaser | Total |
Foot rugs | 25 | |
Amplifier Total | 0 | |
Sandwich | 984 | |
Can opener | 659 | |
Mouse Total | 0 | |
Keyboard | 87 | |
Flask | 7 | |
Switch | 7 | |
Hat Total | 0 | |
Eyeglass | 676 | |
Shoes | 75 | |
Phone Total | 0 | |
Microphone | 99 | |
Box | 3 |
<tbody>
</tbody>
As you can see, the cells in column C with the word Total in column A are zero. The zeroes must be replaced by 1. I am totally in the dark on how to replace it using the word Total. I'm still grasping the basics of vba and I need to do it using vba only. I've been searching for a code that will fit my need but no luck. Any suggestion will be appreciated. Thank you!