This is the code from that threadIt is already pasting the values. See this line![]()
Sub MoveNumbers() Dim i As Long Dim j As Long j = 12 For i = 5 To 22 If Cells(i, 38).Value > 0 Then Cells(j, 1).Value = Cells(i, 38).Value j = j + 1 End If Next i End Sub
![]()
Cells(j, 1).Value = Cells(i, 38).Value
Bookmarks