Hello Board,
I am new to board and dumb, hoping someone would share a simple VBA code
I have a large table of data of ~10000 rows.
I'd like VBA Code to loop through:
1) evaluate data in column A for cells that contains 5 characters ending in letter "X"
2) If it finds such, I'd like to change text in column C to "Group"
For Example: In this it would change C2 and C3 to "Group" since A2 and A3 ID#'s contain 5 letters and end in X
<tbody>
</tbody>
Thanks for any help
I am new to board and dumb, hoping someone would share a simple VBA code
I have a large table of data of ~10000 rows.
I'd like VBA Code to loop through:
1) evaluate data in column A for cells that contains 5 characters ending in letter "X"
2) If it finds such, I'd like to change text in column C to "Group"
For Example: In this it would change C2 and C3 to "Group" since A2 and A3 ID#'s contain 5 letters and end in X
A | B | C | |
1 | ID# | AMOUNT | TYPE |
2 | RBFCX | 5001 | Single |
3 | TLSHX | 4006 | Indiv |
4 | VA9827 | 8542 | Single |
5 | UDGSX | 9865 | Group |
<tbody>
</tbody>
Thanks for any help