Copy data

[Panoos64]

Hi to all of you, Kindly require to provide me support with VBA code, so that that if text, date or numbers e.t.c. exist in col. “M” or “N” to copying and place them in Col. “A”. Therefore, that the numbers of rows are around 500. I present below original data and expected result. Thank you all in advance

Original data

Expected result

 

[Fluff]

How about

Sub panoos()
   With Range("A7:A" & Range("L" & Rows.Count).End(xlUp).Row)
      .Value = Evaluate(Replace(Replace("If(@m<>"""",@m,if(@n<>"""",@n,""""))", "@m", .Offset(, 12).Address), "@n", .Offset(, 13).Address))
   End With
End Sub

 

[Panoos64]

Many thanks once again Fluff! Is perfect and is what exactly i requested. i express my admiration to you for your continue support. Hv a great day!!

 

[Fluff]

My pleasure & thanks for the feedback.