Excel 2007 : Skip columns on condition

Hi,

I previously worked on SPSS data entry version where we can apply skipping instructions like if code 1 entered in A then focus moves to C else B. Now someone told me to switch to Excel due to its friendly GUI and widely familiarity. My question:

I applied checks on columns using data validation. Now I want if the data entry operator enters 1 in A then the focus automatically moves to C else to B.

Please find attached sheet for your convenience.

Thanks.

That would require VBA. i don't know much about VBA. You can try this in a COPY of your file.

Right click from the sheet name & click View Code then paste this in the white box shown on right side.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column <> 1 Or Target.Count <> 1 Then Exit Sub
    If Target.Value = 1 Then
    Target.Offset(, 2).Select
    End If
End Sub

See the attached. You must save your file As Excel Macro Enabled Workbook.