need code to pull row onto new sheet

[patty123467]

How do I say:

If column T has a 0, move that rows column J-S onto sheet2 on en empty row.

Thanks!

 

[Smitty]

How is column T changing, via formula or manual entry?

One quick way is to use AutoFilter on column T, then Goto-->Special-->Visible Cells only, then copy/paste. That's all easily recordable, and if you post back what you get someone can set it up to copy to a blank row.

 

[patty123467]

I am doing a v-lookup to get the 0 into the T field (would love for this to be automatic too). Then I want to be able to run a macro that will take all of the rows with a 0 and copy and paste cells J-S into the other sheet on a blank row. Just columns J-S.

 

[Smitty]

What do you do with the 0 rows once they've been copied? If they get deleted no problem, but if not then how do you prevent duplicates in the destination sheet?

Did you try the AutoFilter method I mentioned?