Hi,
rather than describe your specific workbook why don't you try to
generalize your question? It sounds to me that you want a
worksheet_change event on sheet CCC that says something like this....

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 15 And Target.Row 9 And Target.Row < 21 Then
Me.Range("$O$10:$O$20").Copy Sheet1.Range("$O$10:$O$20")
End If
End Sub

Hth,
O