THANKS CARIM. WILL GIVE IT A TRY and let you know how it works out.
Appreciate your assistance.

"Carim" wrote:

Hi,


Something along these lines ...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$H$11" Then
Application.EnableEvents = False
If Target.Value = 12 Then
place your code to copy
End If
Application.EnableEvents = True
End If
End Sub

HTH
Cheers
Carim