Scan column for text and copy specific range thenpaste into diff column on diff sheet

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.

Please Login or Register  to view this content.

Hi.....can you try this once....

Please Login or Register  to view this content.

I gave that a try to no avail. Am i crazy or am i just VBA impaired? It looks like your code is identical to mine except for the "application.screenupdating = false" and "application.screenupdating = true" at the beginning and end of the code. I tried to paste to column M in "MasterSheet" by changing "cells(r,1).select" to "cells(r,13).select"and i get same error..... error1.PNG. Or am i doing something completely wrong?