how can you auto return from columns B1 to A2

A

arran tw

lets say you r using just 2 columns A and B all i want to do is return to the
start of the next line which would be a2 and so, oh if you highlight both
columns it will return to the next line can you do it with out hightlighting.
 
S

Stefi

Install this Change event sub:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Range("A" & Target.Row + 1).Select
End If
End Sub

It will return to column A in the next line after filling cells in column B.
Please post if you need help to install it!

Regards,
Stefi

„arran tw†ezt írta:
 
S

Stefi

Hi Arran,

Press Alt-F11 (launches VB window)
Right Click on your worksheet in the Project window
Choose View code from the local menu
Copy and Paste there the Sub

Regards,
Stefi


„arran tw†ezt írta:
 
G

Gord Dibben

Arran

Another option not involving code.

Start in column A, enter data then hit TAB to go to column B.

Enter data then hit ENTER key to drop down and back to Column A.




Hi Arran,

Press Alt-F11 (launches VB window)
Right Click on your worksheet in the Project window
Choose View code from the local menu
Copy and Paste there the Sub

Regards,
Stefi


„arran tw” ezt írta:
Click to expand...

Gord Dibben MS Excel MVP
 
Top