sum if macro VBA

[abazdi]

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.

 

[iliace]

You can use AutoFilter to isolate all rows in which a particular column = x.

 

[MNpoker]

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.

Do While Column 1 is not blank
z = z + 1
If Range("A1").offset(z,0) = 'x' Then (Other Sheet) Range = what is on the other sheet **
Loop

** There are a variety of ways to do this.

Next question (I like macros but) can you just put a formula in the other sheet like =If(sheet1!A1 = "x", Sheet1!B1, "")