Hi

This may get you started:

Right-click on the sheet tab and select View Code.

Paste this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target < Range("A1") Then Exit Sub
If Range("A1").Value = "bob" Then
Range("A2").Value = Range("B1").Value
End If
End Sub

The code only runs if cell A1 has been changed and only checks to see
if "bob" has been entered in that cell, if it has then if copies the
data in B1 to A2.

Regards

Steve