Private Sub worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Column = 8 And Target.Row = 12 Then Worksheets(MonthName(Month(Worksheets("Blanko").Range("H12")))).Range("A" & Worksheets(MonthName(Month(Worksheets("Blanko").Range("H12")))).Cells(Rows.Count, 1).End(xlUp).Row + 1) = Worksheets("Blanko").Range("H12") Worksheets("Blanko").Range("F50:I50").Copy Sheets(MonthName(Month(Worksheets("Blanko").Range("H12")))).Range("B" & Worksheets(MonthName(Month(Worksheets("Blanko").Range("H12")))).Cells(Rows.Count, 2).End(xlUp).Row + 1) End If Application.EnableEvents = True End Sub
ich liebe spam :-))
Private Sub CommandButton1_Click() Dim Lzeile As Long With Worksheets(MonthName(Month(Worksheets("Blanko").Range("H12")))) .Range("B40:E40") = "" Lzeile = .Cells(Rows.Count, 2).End(xlUp).Row + 1 .Range("A" & Lzeile) = Worksheets("Blanko").Range("H12").Value Worksheets("Blanko").Range("F50:I50").Copy .Range("B" & Lzeile).PasteSpecial Paste:=xlValues, Operation:=xlNone .Range("B40") = Application.WorksheetFunction.Sum(.Range("B5:B39")) .Range("C40") = Application.WorksheetFunction.Sum(.Range("C5:C39")) .Range("D40") = Application.WorksheetFunction.Sum(.Range("D5:D39")) .Range("E40") = Application.WorksheetFunction.Sum(.Range("E5:E39")) End With End Sub
58.4k Fragen
249k Antworten
7k Nutzer