copy row to new tab with condition

**jfdind** · 10-29-2009, 06:20 PM

I am looking to find a way to automatically copy rows from worksheet 1 to worksheet 2 in an excel file when the value in a certain column is greater than zero, could someone please explain to me how to do this.

**JBeaucaire** · 10-29-2009, 06:43 PM

Hif JFDIND, welcome to the forum.

There are many ways to do this, the easiest being adding an INDEX/KEY column to your worksheet 1 to give an incremental number to the rows that match...then use an INDEX/MATCH on worksheet 2 to dynamically display the incremented rows from sheet1.

If you post up a reasonable sample workbook, I can show you more directly what I mean. Click GO ADVANCED and use the paperclip icon to post up your workbook.

**jfdind** · 10-29-2009, 08:03 PM

Thanks for the quick reply.

What I want to do is have it so when column O equals greater than 0 it will take that row and paste it into the other sheet, I have attached an example of the worksheet as requested.

Thanks,
Adam.

**JBeaucaire** · 10-29-2009, 08:16 PM

1) Click in row1
2) Select Data > Filter > AutoFilter to turn on the AutoFilter
3) Click on the dropdown in column O
4) Select Custom
5) Filter by Greater than: zero
6) All the matching rows are showing, now you can quickly copy them all at once to your other sheet.

7) Click Data > Filter > AutoFilter to turn the filter off