PDA

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



Pete
12-02-2008, 02:37 AM
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
12-02-2008, 03:15 AM
Ok here is my clear contents macro

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

Bob Phillips
12-02-2008, 03:22 AM
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

Pete
12-02-2008, 03:29 AM
xld

thanks once again sir....