Excel VBA - Concatenate Module for Multiple Lines

[Reqless]

Hi all. I am new to excel VBA and I am trying to create a module that will concatenate multiple lines.

Here is an example of data from the excel workbook:

Once the macro is executed, I would like the result to look like this:

Any information would greatly appreciated. Thank you in advanced to anyone willing to contribute.

 

[Michael M]

you can "call" other macros from one main macro.
Say you have the MM1 macro and want to run a couple of others....MM2 and MM3
you could.....

Sub MM1()
    With Range("B2:B200")
        .Value = Evaluate(.Address & "& "" "" & " & .Offset(, 1).Address & " & "" "" &  " & .Offset(, 2).Address)
        .Offset(, 1).Clear
        .Offset(, 2).Clear
    End With
Range("C:D").EntireColumn.Delete
[color=red]Call MM2
Call MM3[/color]
End Sub

So once MM1 had done it's work..macro MM2 would run followed by macro MM3, without needing your input.
Is that what you wanted ??

 

[Reqless]

Precisely.

These macros are so interesting. Never knew about any of this stuff until recently. Thanks again for all the help and the quick responses!

 

[Michael M]

Glad to help.....