How in VBA can i fill in the blank rows and fill them...it needs to find the name after the blank and copy both fields to the above cells. Appreciate any help :)
So from this.....
<tbody>
V00006
Action Office Machines P/L
V03393
Active Sound Services
V03271
Adaptalift Group Pty Ltd...