Copy rows/column to Another worksheet based on cell value

New to the forum - hopefully I can find a resolution to something I'm trying to do. I'm using Excel 2003.

File is attached.

I want to be able to copy columns D-P and all rows that meet the following criteria:
Column D (Order Qty) on "Equipment Order List" worksheet is greater than 0, copy to "Equipment Order Final"

Also, where would I put this code?

Thanks in advance

In addition to what JieJenn has suggested if you were to want to use a macro this could be one way of doing it.

Please Login or Register  to view this content.

Originally Posted by JieJenn

Why not use Advanced Filter?

That's true, I could do that....not sure why I was trying to make it so difficult LOL

Originally Posted by stnkynts

In addition to what JieJenn has suggested if you were to want to use a macro this could be one way of doing it.

Please Login or Register  to view this content.

thanks...I will give this a try also