Offset after the 2 columns.

Hi,

I need your small help guys.

I get this code from this forum. i need something to add the code for offset in the 2 column only. like this sample.Screen Shot 2019-06-12 at 9.03.48 PM.jpg

only 2 columns (C and D). after I enter the name in Column C3 & D3 automatic return in C4 after I press the enter.

here the code:

Please Login or Register  to view this content.

Please need your help guys.

Thanks

Thanks Paul for you quickly response.

One more help. same but different code. I need in column A and B only then return in A2 when i press enter. see below code.

Please Login or Register  to view this content.

where can I add this code
If Not Intersect(Target, Range("D:D")) Is Nothing Then
Range("C" & Target.Row + 1).Activate
ElseIf Not Intersect(Target, Range("A:B")) Is Nothing Then
Range("A2").Activate
End If


"So if you make any change in columns A or B, you want the active cell to be A2 afterward? Then adjust the If statement like so:"
same in the picture above. But now this code different.

When I type the name in A1 and B1 the press enter automatic return in A2 to continue add the name.