Option
Explicit
Sub
Schaltfläche61_Klicken()
Dim
Zeile
As
Long
Dim
Target
As
Range
Set
Target = Range(
"A1:A1000"
).Find(What:=
"Verschieben"
, LookIn:=xlFormulas)
If
Target
Is
Nothing
Then
Exit
Sub
Zeile = Target.Row
Range(Cells(Zeile, 2), Cells(Zeile, 50)).Copy _
Destination:=Sheets(
"Laufende Bewerbungen"
).Cells(Rows.Count, 2).
End
(xlUp).Offset(1, 0)
Range(Cells(Zeile, 2), Cells(Zeile, 50)).ClearContents
End
Sub