Excel VBA help copying and pasting text to a new row

[Ramatulai]

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

[k64]

Assuming you have your current text in row 1 and want your results in A2 and down, this code should work.

Please Login or Register  to view this content.