ich benötige einen Code/ Formel, welche die Fkt. hat, dass wenn ich in Spalte "G" etwas eintrage ("J") automatisch in die in die Spalte "U" springt. Selbe Zeile.
Über Hilfe würde ich mich sehr freuen
VLG Dan
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 7 Then
If Target <> "" Then Cells(Target.Row, 21).Select
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngB As Range, rng As Range, ii As Integer
Set rngB = Intersect(Target, Range("G4:G789"))
If rngB Is Nothing Then Exit Sub
For Each rng In rngB
If UCase(rng) = "J" Then
rng = "J"
For ii = 8 To 17
If IsEmpty(Cells(rng.Row, ii)) Then Cells(rng.Row, ii) = rng
Next ii
End If
Next rng
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngB As Range, rng As Range, ii As Integer
Set rngB = Intersect(Target, Range("G4:G789"))
If rngB Is Nothing Then Exit Sub
On Error GoTo ErrorHandler
Application.EnableEvents = False
For Each rng In rngB
If UCase(rng) = "J" Then
rng = "J"
For ii = 8 To 17
If IsEmpty(Cells(rng.Row, ii)) Then Cells(rng.Row, ii) = rng
Next ii
End If
Next rng
Cells(Target.Row, 21).Select
Application.EnableEvents = True
Exit Sub
ErrorHandler:
Application.EnableEvents = True
MsgBox Err.Description, vbCritical, "Fehler " & Err.Number
End Sub