ich möchte gerne eine Tabelle in ein anderes Format bringen. Es geht hier wohl hauptsächlich um "Transportieren".
Im Anhang findet ihr die genauere Beschreibung.
Vielen Dank vorab.
Jonas
https://www.herber.de/bbs/user/96635.xlsx
Sub umformen()
Dim arr1
Dim arr2
Dim z1 As Long, s1 As Long
Dim z2 As Long, s2 As Long
Dim FIL As String
Dim DAT As Long
Dim VER As String
Dim MAN As Long
arr1 = Cells(1, 1).CurrentRegion.Value
ReDim arr2(1 To (UBound(arr1, 1) - 1) * 12, 1 To 6)
DAT = 201500
MAN = 1
For z1 = 2 To UBound(arr1, 1)
VER = arr1(z1, 1)
FIL = WorksheetFunction.VLookup(arr1(z1, 2), Range("L12:M15"), 2, 1)
For s1 = 3 To 14
z2 = z2 + 1
arr2(z2, 1) = DAT + s1 - 2
arr2(z2, 2) = VER
arr2(z2, 3) = MAN
arr2(z2, 4) = FIL
arr2(z2, 5) = arr1(z1, s1)
arr2(z2, 6) = Now
Next
Next
Cells(13, 1).Resize(UBound(arr2, 1), UBound(arr2, 2)) = arr2
End Sub
Gruß Daniel