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