Hello Everyone,

I'm new to Excel VBA would appreciate anyone that is kind enough to help me. I'm trying to write a macro that looks in cell A1:VGH1 for the text "Name:" within the row, then copy that cell and other following cells and paste into a new row. This macro can loop through the row until all instances of the text "Name:" and the following cells are on their own row. Thank you soo much in advance.


What I have currently.

Name:xxx From:xxx Name:xxx To:xxx From:xxx Name:xxx: To:xxx

The result

Name:xxx From:xxxx
Name:xxx To:xxx From:xxxx
Name:xxx To:xxx