thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Guys, is there a way to via vba move all of the names so there are no gaps so example 1 looks like example 2. The data is currerntly in range c22 to E40 in sheet called 'Allocate'
EXAMPLE 1
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
EXAMPLE 2
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
EXAMPLE 1
Name1 | Name2 | Name3 |
Angela Rose | ||
Bethan Mason | Angela Rose | |
Chloe Whitfield | Bethan Mason | |
Angela Rose | ||
Chloe Whitfield | ||
Angela Rose | ||
Lorna Young | ||
Bethan Mason | ||
Nicole Foxwell | ||
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
EXAMPLE 2
Name1 | Name2 | Name3 |
Angela Rose | Bethan Mason | Angela Rose |
Bethan Mason | Chloe Whitfield | Angela Rose |
Chloe Whitfield | Bethan Mason | Angela Rose |
Lorna Young | ||
Nicole Foxwell |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>