Hi all, Kindly advice me for a VBA code so that to move the duplicate numbers from credit side which is col. "J" to col "I". Note that the code should move the second number. I present below an extract of original data and expected result. Thank you all in advance
Original data
<colgroup><col style="mso-width-source:userset;mso-width-alt:995;width:21pt" width="28"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> </colgroup><tbody>
</tbody>
Expected result
<colgroup><col style="mso-width-source:userset;mso-width-alt:995;width:21pt" width="28"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> </colgroup><tbody>
</tbody>
Original data
Debit | Credit | |
I | J | |
2 | 75.25 | |
3 | 75.25 | |
4 | 1500.88 | |
5 | 1500.88 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:995;width:21pt" width="28"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> </colgroup><tbody>
</tbody>
Expected result
Debit | Credit | |
I | J | |
2 | 75.25 | |
3 | 75.25 | |
4 | 1500.88 | |
5 | 1500.88 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:995;width:21pt" width="28"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2531;width:53pt" width="71"> </colgroup><tbody>
</tbody>