Macro to clear content and move data one column to the right

See attached workbook.
Hi Experts

Ok i have no idea on this question.

Need a macro that will delete/remove any N/A that appear in column in column D (see worksheet "Latam Santander") after the word Milestone. Boarders not to be chnaged or affect.

And also copy across from column J to column K (same worksheet) any text/information that appears in column J over to K. With out the red back ground colour, just plain text white transparent background.

Ok here is my clear contents macro

Code:

---

For Each Cel In Range("D:D")
    If Cel.Value = "N/A" Then
        Cel.Value = ""
    End If
Next Cel

---

how would i do the movement from column j to k....and combine the results

Code:

---

Dim Cel As Range
    For Each Cel In Range(Range("D15"), Range("D" & Rows.Count).End(xlUp))
    If Cel.Value = "N/A" Then
        Cel.Value = ""
        Cel.Offset(0, 7).Value = Cel.Offset(0, 6).Value
        Cel.Offset(0, 6).Value = ""
    End If
    Next Cel

---

xld

thanks once again sir....