Great god genuflect is begged help do form set conditional jumps cell under the great god help do form genuflect is begged set conditional jumps cell under the great god help do form genuflect is begged set conditional jumps cell

CodePudding user response:

The building should be a "fantasy"!
Never heard of this software can support the "condition"...

CodePudding user response:

This can only by VBA code, was possible,

CodePudding user response:

As shown in figure in the macro editor interface selection sheet, then you can have a lot of events for sheet can choose, choose change event, for example, when you the content change of cell, can produce events, you can according to the events in the range of judgment, and then focus on the jump

CodePudding user response:

Put the following code in the above position, and stick to the point!

 
Private Sub Worksheet_Change (ByVal Target As Range) 
If the Target. The Column=1 Then 
Cells (Target. Row, 3). Select 
ElseIf Target. The Column=3 Then 
The Select Case Target. The Text 
Case "a" 
Cells (Target. Row, 5). Select 
Case "into" 
Cells (Target. Row, 8). Select 
Case "deposit" 
Cells (Target. Row, 11). Select 
Take "Case", "
Cells (Target. Row, 12). Select 
End the Select 
ElseIf Target. The Column=5 Or Target. The Column=8 Or Target. The Column=11 Or Target. Then the Column=12 
Cells (Target. Row + 1, 1). Select 

End the If 
End Sub 

CodePudding user response:

The

reference 4 floor chewinggum reply:

put the following code in the above position, and stick to points
........

The original poster is "Settings" according to conditions, not by executing code,

CodePudding user response:

Look at the code generation technology?