Macro to skip columns during data entry

[mousepant]

Hi,

I am a data entry specialist and I have 20 columns and 3000 rows to fill. column B, C are already filled. I give tab to go to next column. I am wondering if a macro can move to column D when I give tab after completing A. There are nearly 3000 rows. I tried recording a macro, but it is not working. I am using Excel 2007.

Thanks in advance for your help.

 

[MandeepBaluja]

Put this code in your sheet event bro Simple

Private Sub Worksheet_Change(ByVal Target As Range)If Not Intersect(Range("A:A"), Target) Is Nothing Then
            Target.Offset(0, 3).Activate
End If
End Sub

 

[mousepant]

Thank you so much. This works great.