
Originally Posted by
michael32
if all variable from y is done than the variable z is running +2
What should it be? 1?
If so take out the z=z+1.
Otherwise, just a guess:
Sub testing()
Dim y As Long
Dim z As Long
For z = 1 To 42
For y = 3 To 8
Sheets("employees").Cells(y, 9).Copy Sheets("Time_data_01").Cells(2, 4).Offset(z, 0)
Next y
z = z + 1
Next z
End Sub