könnte mal wieder ein wenig Hilfe gebrauchen.
würde gern bei aktivierter Checkbox in Tabelle 1 die Zeile in Tabelle 2 kopieren und aus Tabelle 1 löschen.
MFG Beno
Sub Makro1()
ActiveSheet.Range("$A$1:$L$31").AutoFilter Field:=12, Criteria1:=">"
With Range("$A$2:$L$31").SpecialCells(xlCellTypeVisible)
.Copy Sheets("Tabelle2").Range("A2")
.Delete
End With
End Sub
Sub Makro2()
ActiveSheet.Range("$A$1:$L$31").AutoFilter Field:=12, Criteria1:=">"
With Range("$A$2:$L$31").SpecialCells(xlCellTypeVisible)
.Copy Sheets("Tabelle2").Cells(Rows.Count, 1).End(xlUp).Offset(1)
.Delete
End With
End Sub
Sub Makro2()
ActiveSheet.Range("$A$1:$L$31").AutoFilter Field:=12, Criteria1:="x"
With Range("$A$5:$L$31").SpecialCells(xlCellTypeVisible)
.Copy Sheets("Produziert").Cells(Rows.Count, 1).End(xlUp).Offset(1)
.Delete
End With
End Sub
Sub Makro2()
With ActiveSheet.Columns(12)
If WorksheetFunction.CountIf(.Cells, "x") > 0 Then
.Replace "x", True
With .SpecialCells(xlCellTypeConstants, 4)
.Value = "x"
.EntireRow.Copy Sheets("Produziert").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
.EntireRow.Delete
End With
End If
End With
End Sub
Sub Makro4()
With ActiveSheet.ListObjects("Tabelle1")
If WorksheetFunction.Count(.ListColumns(12).DataBodyRange, "x") > 0 Then
.Range.AutoFilter Field:=12, Criteria1:="x"
With .DataBodyRange.SpecialCells(xlCellTypeVisible)
.Copy Sheets("Produziert").Cells(Rows.Count, 1).End(xlUp).Offset(1)
.Delete
End With
Else
MsgBox "Nix x gefunden"
End If
End With
End Sub