Sub Macro3()
Dim T As Variant, Ta As Variant, Tb() As Variant
With Sheets("BRUT")
Ta = .Range("A1:D1").Value
T = .Range("A2:G" & .Range("A65000").End(xlUp).Row).Value
For i = 1 To UBound(T, 1)
x = x + 1
ReDim Preserve Tb(1 To 6, 1 To x)
Tb(1, x) = T(i, 1)
Tb(2, x) = T(i, 2)
Tb(3, x) = T(i, 3)
Tb(4, x) = T(i, 4)
Tb(5, x) = .Range("E1")
Tb(6, x) = T(i, 5)
x = x + 1
ReDim Preserve Tb(1 To 6, 1 To x)
Tb(1, x) = T(i, 1)
Tb(2, x) = T(i, 2)
Tb(3, x) = T(i, 3)
Tb(4, x) = T(i, 4)
Tb(5, x) = .Range("F1")
Tb(6, x) = T(i, 6)
x = x + 1
ReDim Preserve Tb(1 To 6, 1 To x)
Tb(1, x) = T(i, 1)
Tb(2, x) = T(i, 2)
Tb(3, x) = T(i, 3)
Tb(4, x) = T(i, 4)
Tb(5, x) = .Range("G1")
Tb(6, x) = T(i, 7)
Next
End With
With Sheets("RESULTAT")
.Range("A1:D1") = Ta
.Range(.Cells(2, 1), .Cells(UBound(Tb, 2) + 1, UBound(Tb, 1))) = Application.Transpose(Tb)
End With
End Sub