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.