Guys please i have a worksheet which was converted from a pdf document and i need to merge these cells together. Below is a sample of what the sheet looks like.
Doing this manually would be time consuming since i have too many rows to work on.
I need a VBA code to look through range A, if is blank, merge everything under the Ref. 1 column up.
e.g "Re-allocation of bi-monthly revenue"
<tbody>
</tbody>
Thanks in advance.
Doing this manually would be time consuming since i have too many rows to work on.
I need a VBA code to look through range A, if is blank, merge everything under the Ref. 1 column up.
e.g "Re-allocation of bi-monthly revenue"
Post Date | Due Date | Type | Trans | Ref.1 | Details | Contra Acct |
11/10/12 | 11/10/12 | PU | 1575 | 72 | A/P Invoice | SMULTI |
11/10/12 | 11/10/12 | PC | 1576 | Re-allo | A/R Invoice -C- Listings | 156510-000 |
cation of | ||||||
bi | ||||||
monthly | ||||||
revenue | ||||||
08/01/13 | 08/01/13 | IN | 2198 | 717 | A/R Invoice -C- Listings | C- Listings |
11/10/12 | 11/10/12 | JE | 1405 | Re-allocation of | A/P Invoice | 645070-0000 |
Bi-monthly income |
<tbody>
</tbody>
Thanks in advance.