Hi,
I m new to VBA and my problem is explained below with example
i need to go from this :
<tbody>
</tbody> In this table , i need to append a text which has no column name. 'A' has to be appended the end of every row until the next occurrence of 1 in column rank . from the second occurrence of 1 in rank column i need 'B' to be append at the end of every row.
after applying the code, it should look like this.
<tbody>
</tbody>
Any help on writing this code will be very much appreciated.
Thanks,
Manvit
I m new to VBA and my problem is explained below with example
i need to go from this :
rank | name |
1 | jon |
2 | alex |
3 | william |
4 | josh |
5 | jamies |
1 | sarah |
2 | angela |
3 | haley |
4 | julie |
5 | sofia |
<tbody>
</tbody>
after applying the code, it should look like this.
rank | name | |
1 | jon | A |
2 | alex | A |
3 | william | A |
4 | josh | A |
5 | jamies | A |
1 | sarah | B |
2 | angela | B |
3 | haley | B |
4 | julie | B |
5 | sofia | B |
<tbody>
</tbody>
Any help on writing this code will be very much appreciated.
Thanks,
Manvit