Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Range("A500").End(xlUp).Select
If ActiveCell <> "" And ActiveCell.Offset(0, 1) = "" Then
ActiveCell.Offset(0, 1).Select
ElseIf ActiveCell <> "" And ActiveCell.Offset(0, 1) <> "" Then
ActiveCell.Offset(1, 0).Select
End If
End Sub