Hi all, i would like to write a vba command so to run through col. "A" and where find the account's description "Telephones & Postages" should convert it to "Telephones / Postages". In 1st schedule is an extracvt of original data and in 2nd is the expected result. Thanks in advance.
<colgroup><col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"> <col style="mso-width-source:userset;mso-width-alt:10422;width:214pt" width="285"> </colgroup><tbody>
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"> <col style="mso-width-source:userset;mso-width-alt:10422;width:214pt" width="285"> </colgroup><tbody>
</tbody>
A | |
1 | Description |
2 | Marketing expenses |
3 | Subscriptions & Donations |
4 | Telephones & Postages |
5 | Sundry expenses |
6 | Management Fees |
<colgroup><col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"> <col style="mso-width-source:userset;mso-width-alt:10422;width:214pt" width="285"> </colgroup><tbody>
</tbody>
A | |
1 | Description |
2 | Marketing expenses |
3 | Subscriptions & Donations |
4 | Telephones / Postages |
5 | Sundry expenses |
6 | Management Fees |
<colgroup><col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"> <col style="mso-width-source:userset;mso-width-alt:10422;width:214pt" width="285"> </colgroup><tbody>
</tbody>