Found this code online and tried using it but i need to be able to only copy column B thru F on sheet "reiterated" then copy to column M on sheet "mastersheet". Im getting error now when i try changing code and running macro and i believe its because im copying entire row therefore it wont allow me to offset the pasting to column M. Any help would be appreciated.
Sub Reiterated()
Dim r As Integer
Dim cell As Range
r = 4
Sheets("Reiterated").Select
For Each cell In Range("E71:E136")
If cell.Value = "Buy" Then
cell.EntireRow.Copy Sheets("MasterSheet").Cells(r, 1)
r = r + 1
End If
Next cell
Sheets("MasterSheet").Select
End Sub
Bookmarks