Macro to copy paste rows if cell value greater than 0

[MPFraser7]

For range (A2:I413), I want to copy all rows where column I is greater than 0 and paste it in a new sheet and format this new sheet as a table. The values in column I range from 0, "", #value !, negative and positive numbers. I want to copy rows where the numbers are positive. Any help on this?

 

[Fluff]

@Yancy
Please start a thread of your own for this.
Thanks

 

[Despot91]

@Fluff Hello! I see you solved similar case like mine and I would really appreciate the help.
What I need is following:
I have two sheets Ponuda and Otpremnica..
1. When cell value in collumn H (H3:H1500) of sheet Ponuda is greater than 0 to copy items below mentioned to sheet Otpremnica (Row 15-200) and move to the next row... I will further try explain as good as I can...

(Example: We enter following amounts in this order on sheet Ponuda
H10 we enter value of 70 ,
H3 we enter value of 120,
H15 we insert quantity 35

1. Insert quantity to H10 sheet Ponuda
- H10 sheet Ponuda to copy to E15 sheet Otpremnica ,
- B10 sheet Ponuda to copy to B15 sheet Otpremnica,
- I10 sheet Ponuda to copy to F15 sheet Otpremnica

2. Insert quantity to H3
- H3 sheet Ponuda to copy to E16 sheet Otpremnica ,
- B3 sheet Ponuda to copy to B16 sheet Otpremnica,
- I3 sheet Ponuda to copy to F16 sheet Otpremnica

3. Insert quantity to H15
- H15 sheet Ponuda to copy to E17 sheet Otpremnica ,
- B15 sheet Ponuda to copy to B17 sheet Otpremnica,
- I15 sheet Ponuda to copy to F17 sheet Otpremnica

^This to be applied for row 3 - row 1500 on sheet Ponuda


Can this be done?
Sorry for bad English and thanks in advance!

 

[Fluff]

Please start a thread of your own. Thanks