Copy and Paste Cells in a Row With the Same Value to Another Worksheet

[timakachev]

Hi,

I am trying to paste cells from one worksheet to another worksheet when the value in a row is 0. So it looks something like this:

H I J K L

1 0 data data data

2 1 data data data

3 0 data data data


Everything that has a 0 before the data I would like to copy and paste into another worksheet. I have tried different macros but I can't get them to work. Does anyone know a way to do this?

Thanks

[singerj6]

I'm assuming there is data in A-G
You'll need to change the Sheet names to fit your workbook

Please Login or Register  to view this content.

[timakachev]

Thanks singerj6,

It somewhat works, but instead of coppying it from current sheet how can I make it copy from Sheet2 to 3 and to copy the rows from column I and up.

Thanks appriciate your help!