Automatically jump to cell

[Guest]

Hi,
I have a sheet where users enter their details. Is there a way, such that, after a user enters data in cell B2, the cell will automatically jump to cell D8?
ie. In cell B2 -> Type '12345' -> Press Enter -> In cell D8

Thanks!

 

[Dave Hawley]

Hi


Right click on the sheet name tab select "View Code" and paste in this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then Range("D8").Select
End Sub