I am working on a macro to reformat an exported report. So fa
everything has been pretty easy going. Now I am at the point where i
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
is blank but the rest of the row is filled with numbers. What I wan
the macro to do is find where Ax starts with “Name:” then take Bx+
(the next row starting with B) and move those numbers to the same ro
as A.

Befo
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!
Oogi

--
Oogi
-----------------------------------------------------------------------
Oogie's Profile: http://www.excelforum.com/member.php...fo&userid=3734
View this thread: http://www.excelforum.com/showthread.php?threadid=57044