Application.ScreenUpdating = False
r = Cells(Rows.Count, 2).End(3).Row
For Each Rng In Application.Intersect(ActiveSheet.UsedRange, Columns(2))
If Rng.Interior.ColorIndex = 3 Then
Range(Rng.Offset(1), Cells(r, 9)).Copy Rng
Exit For
End If
Next
For j = 2 To 9
Cells(r, j) = 0
Next j
ActiveSheet.UsedRange.Borders.LineStyle = xlContinuous
Application.ScreenUpdating = True