Quote Originally Posted by michael32 View Post
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