Der Code:
Private Sub CommandButton1_Click()
Dim zeile As Long, wks As Worksheet
zeile = TextBox1.Value
For Each wks In Worksheets
If wks.Name Like "*Umsatz*" Then _
wks.Cells(zeile, 3).EntireRow.Insert Shift:=xlDown
Next
For Each wks In Worksheets
If wks.Name Like "*Umsatz*" Then
With wks
.Rows(zeile - 1).Copy .Cells(zeile, 1)
.Cells(zeile, 3) = TextBox2.Value
End With
End If
Next
End Sub
Datei liegt bei
https://www.herber.de/bbs/user/60349.xls
DANKE!! gruß leo