Hi Guys,
Need your help on concatenating records.
Just made adjustment on my Macro codes. Filtering of records before dumping/copy to template is working.
My problem is how could i concatenate the columns. Right now i have 24 columns (A,V) in my data source. I need to
concatenate the column A,E then insert to column F. another, concatenate column A,E,I,M and insert to column N.
Your help is very much appreciated.

The result should be like this format when dumping to tempate.
Column A-B-C-D-E-Concatenated column(A+E)=F,G-H and so on. 

    'dumping of data to template
    With ws
        lrow = .Range("A" & Rows.Count).End(xlUp).Row
        .Range("A4:V" & lrow).AutoFilter Field:=1, Criteria1:="Line1"  'just added to Filter records
        .Range("A4:V" & lrow).Copy wstemp.Range("A1")
    End With