I am new to VBA scripting.
I want to combine string data to corresponding first cell.
I will select required rows of data.
Based on the selection it should combine data.
Example: if I select 1st row required cells (2/3/4 cells), combine all data from selected cells and paste in 1st cell of same row.
I have tried a way, but it is taking more time then manual process.
3
This is another approach, only for the specific task.
Sub concat_cells()
For Each coll In Selection.Rows
Selection.Parent.Cells(coll.Row, 1) = WorksheetFunction.TextJoin("_", True, coll)
Next coll
End Sub