How to Make Excel Move Automatically to the Defined cell position

[pankajgrover]

Here is example. I want if i input value "S" only in F3 cell, then automatically excel or cursor move to M3 cell. It should happens only when "S" type otherwise normal default move. How to do that, Thanks.

Shares Trading.xlsx
	A				E	F	G	H	I	J	K	L	M
2	Name				Partners	B/S	Date	Qty	Price	Amount	S.Name	S.Partners	S.Date
3	Silver				Pankaj	S					Silver	Pankaj
Sheet1

Cell Formulas
Range	Formula
J3	J3	=((H3*B3)*I3)
K3	K3	=Sheet1!$A3
L3	L3	=[@Partners]

Cells with Data Validation
Cell	Allow	Criteria
A3:A86	List	=Shares
E3:E86	List	=Partners

 

[Joe4]

You will need VBA code to do this.

Right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste this code in the resulting VB Editor window:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.CountLarge > 1 Then Exit Sub
   
'   If "S" is entered in column F, jump to column M
    If Target.Column = 6 And Target.Value = "S" Then
        Target.Offset(0, 7).Select
    End If
   
End Sub

Then any time you enter "S" in a cell in column F, you cursor will jump to column M of the same row.

 

[pankajgrover]

You will need VBA code to do this.

Right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste this code in the resulting VB Editor window:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.CountLarge > 1 Then Exit Sub
  
'   If "S" is entered in column F, jump to column M
    If Target.Column = 6 And Target.Value = "S" Then
        Target.Offset(0, 7).Select
    End If
  
End Sub

Then any time you enter "S" in a cell in column F, you cursor will jump to column M of the same row.

Wow Thanks Working. Also pls guide me i am doing some stocks closing price work. I want if i run or hit any key or any code macro then copy certain cells value to another cells. here is example below . i want when run code then copy AJ Cells to AN only values by hit any key or code otherwise not copy .. How to do that this Thanks

Shares Trading.xlsm
	AJ				AN
3	56324.00				56324.00
4	69427.00				69427.00
5	459.65				449.60
6	2446.95				2448.33
7	69427.00				69069.00
Vishal

Cell Formulas
Range	Formula
AJ3:AJ7	AJ3	=D3
AN7	AN7	=IF($AK7="","",IF($AK7="B",I7,P7))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AL3:AN30	Expression	=$AK3="S"	text	NO
AL3:AN30	Expression	=$AK3="B"	text	NO

 

[Joe4]

Wow Thanks Working. Also pls guide me i am doing some stocks closing price work. I want if i run or hit any key or any code macro then copy certain cells value to another cells. here is example below . i want when run code then copy AJ Cells to AN only values by hit any key or code otherwise not copy .. How to do that this Thanks

Shares Trading.xlsm
	AJ				AN
3	56324.00				56324.00
4	69427.00				69427.00
5	459.65				449.60
6	2446.95				2448.33
7	69427.00				69069.00
Vishal

Cell Formulas
Range	Formula
AJ3:AJ7	AJ3	=D3
AN7	AN7	=IF($AK7="","",IF($AK7="B",I7,P7))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AL3:AN30	Expression	=$AK3="S"	text	NO
AL3:AN30	Expression	=$AK3="B"	text	NO

You are welcome.
That is a whole new and different question, and should therefore be posted in a new thread.

 

[pankajgrover]

You are welcome.
That is a whole new and different question, and should therefore be posted in a new thread.

okay. I do in new thread, can i convert this post also to in new thread from here?