I am looking for a macro to copy certain columns from one sheet to another if the code in a column = x. So its if column code = x in sheet 1, copy columns 1,2,3,4 to the other sheet because i am trying to only copy/paste data related to column code x and not if code is somethin else.