Have Excel go automatically to Column “P”

[ar]

I enter data in the first few columns (A, B, C, etc.) and then I have to jump to column “P”. Is there a method where I can press a shortcut key or a Marco and it will automatically go to Column “P”?

[Mark O'Brien]

I don't know if you'd be interested in something like this, but try following my instructions on this post, using the columns you want to be able to access:

http://www.mrexcel.com/board/viewtop...6661&forum=2&1

HTH

[davidtrickett]

This macro in the worksheet code will do the trick - and a little more!

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If ActiveCell.Column < 4 Then
ActiveCell.Offset(0, 1).Select
Exit Sub
End If
If ActiveCell.Column = 16 Then
ActiveCell.Offset(1, -15).Select
Exit Sub
End If
Cells(ActiveCell.Row, 16).Select
End Sub

What this does is to move the selection one column to the right when anything is entered in cols A-C, then jumps to col P. When anything is entered in col P the selection jumps back to col A, one row down.

This only works if the enter key is used - if the arrow keys are used it will confuse the poor thing. This can be rectified but the code is rather more complex.

Hope this helps