I am working on a macro to reformat an exported report. So far everything has been pretty easy going. Now I am at the point where it gets bit complex.

In column A I have multiple cell that start with the word “Name: (persons name)” the rest of that row is blank. The next row, column A is blank but the rest of the row is filled with numbers. What I want the macro to do is find where Ax starts with “Name:” then take Bx+1 (the next row starting with B) and move those numbers to the same row as A.

Before:
A B C D
1 Name: John Doe
2 10 19.95 15
3 Name: Sue Smith
4 40 15 99
5 Totals 50 34.95 114

After:
A B C D
1 Name: John Doe 10 19.95 15
2
3 Name: Sue Smith 40 15 99
4
5 Totals 50 34.95 114


So, can anyone help me with this?

Thanks in advance!
Oogie