how to skip a column when entering data?

  • Thread starter Thread starter Godzilla
  • Start date Start date
G

Godzilla

On one worksheet, for the sake of appearance Column B contains a
calculated amount, which is the product of Column A and Column C.

Is there a way to skip to column C when entering the data in Column A
without doing it manually?

Thanks,

Godzilla
 
This will give you the idea. right click on sheet tab>view code>insert
this>SAVE

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 2 And Target.Column = 1 Then ActiveCell.Offset(, 2).Select
End Sub
 
One method.......

Select columns A and C. Format>Cells>Protection. Uncheck "locked" box.

Tools>Protect>Sheet

Enter data in A1 and hit right-arrow key or Tab key to go forth and back from
Column A to C. Or set Enter key to go right when hit. Tools>Options>Edit
"move selection after Enter"

Gord Dibben Excel MVP XL2002
 
Back
Top