Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 216
- Office Version
- 2019
- Platform
- Windows
I am doing data entry in the excel sheet starting from column A to AB, I want a macro that if in the F column I put a text "C" then when i will press enter then the cell will move to K column then with next enter Q column then with next enter to W column in same row.
I got a piece of code
With the above code when data enters in B25 then it jumps to H26 & so on....
By using the same principle is it possible to create a VBA macro to do so ??
I got a piece of code
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 25 And Target.Column = 2 Then
Cells(26, 5).Select
Else
If Target.Row = 26 And Target.Column = 5 Then
Cells(50, 5).Select
Else
If Target.Row = 50 And Target.Column = 5 Then
Cells(51, 8).Select
End If
End If
End If
End Sub
With the above code when data enters in B25 then it jumps to H26 & so on....
By using the same principle is it possible to create a VBA macro to do so ??