Im trying to re write this macro to copy from R1 to R200 not entire column R. This what I have so far!!
Sub MoveEstimate_to_Order()
Dim i As Long
Dim LR As Long
Dim MyCol As Integer
Dim MyRow As Integer
LR = Sheets("Estimate").Range("R" & Rows.Count).End(xlUp).row
MyCol = 6
MyRow = 24
For i = 1 To LR
If Sheets("Estimate").Range("R" & i).Value <> "" Then
Sheets("Order").Cells(MyRow, MyCol).Value = Sheets("Estimate").Range("R" & i).Value
MyCol = MyCol + 2
If MyCol = 14 Then
MyCol = 2
MyRow = MyRow + 1
End If
If MyRow = 44 Then
MsgBox "You have ran out of room. Some entries were not copied"
Exit For
End If
End If
Next i
End Sub
Bookmarks