Sub rea_destock()
If ActiveSheet.Name <> "S" Then Exit Sub
Dim cel As Range: Application.ScreenUpdating = 0
With Worksheets("J")
Set cel = .Cells(.ListObjects("journal").ListRows.Count + 1, 1)
[A2:G2].Copy: cel.PasteSpecial -4163: cel.Offset(, 7) = [B4]
cel.Offset(, 8) = [B6]: cel.Offset(, 9) = [B8]
[D8:E8].Copy: cel.Offset(, 10).PasteSpecial -4163
End With
[B4, B6, B8, D8:E8].ClearContents
Application.CutCopyMode = 0
End Sub