Sprawdź poniższą wersję - minimum.
Sub herbata()
Dim i As Long, j As Integer, wiersz As Long
Sheets("Arkusz2").Activate
wiersz = 1
With Sheets("Arkusz1")
For i = 5 To 13
For j = 4 To 17
If .Cells(i, j) <> "" Then
wiersz = wiersz + 1
Cells(wiersz, 1) = .Cells(i, 3)
Cells(wiersz, 2) = .Cells(4, j)
Cells(wiersz, 3) = .Cells(i, j)
End If
Next j
Next i
End With
End Sub |