Hello there,
I have a problem that hopefully someone can help me with. I need names and invoice numbers in column A to be placed in separate columns (B & C).
If you refer to my example below, column A is the data I have now, and columns B & C are what I need it to be.
<tbody>
</tbody>
Any help someone can give in VBA form would be great. I have tried, but my knowledge of the syntax is very limited. Thanks!
I have a problem that hopefully someone can help me with. I need names and invoice numbers in column A to be placed in separate columns (B & C).
If you refer to my example below, column A is the data I have now, and columns B & C are what I need it to be.
- The name needs to be in the same row as the number indicating that this number belongs to this person.
- The names need to be listed next to each number.
- There is a blank cell below each person in my current data. I need these blank cells to remain present in B & C after the data is separated. The result should be two blank cells in between each name after the first person.
A | B | C |
Doe, John | ||
1111 | Doe, John | 1111 |
2222 | Doe, John | 2222 |
Smith, Ron | ||
3333 | Smith, Ron | 3333 |
Jones, Brad | ||
4444 | Jones, Brad | 4444 |
5555 | Jones, Brad | 5555 |
6666 | Jones, Brad | 6666 |
<tbody>
</tbody>
Any help someone can give in VBA form would be great. I have tried, but my knowledge of the syntax is very limited. Thanks!