Solved: macro to clear content and move data one column to the right

[Pete]

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.

[Pete]

Ok here is my clear contents macro

For Each Cel In Range("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

[Bob Phillips]

[vba]

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
[/vba]

[Pete]

xld

thanks once again sir....