Pete,

You need to use the Change event code. Right-click the appropriate sheet tab
and choose View Code. This will take you to that sheet's object module in
the VBA editor.  Paste in the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
   '''''''''''''''''''''''''''''
   ' Restrict actions to A1:A10)
   '''''''''''''''''''''''''''''
   Dim ISect As Range
   Set ISect = Application.Intersect(Me.Range("A1:A10"), Target)
   If ISect Is Nothing Then
       Exit Sub
   Else
       If ISect.Cells.Count <> Target.Cells.Count Then
           Exit Sub
       End If
   End If
   Application.EnableEvents = False
   Target.Cells(Target.Cells.Count)(2, 1).Select
   Application.EnableEvents = True

End Sub

This code will select the cell below the paste operation after the paste. As
written, it will apply only to changes in the range A1:A10. Change that
range reference as appropriate.