Formula for excel needed

[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!

 

[mole999]

This site does not provide solutions on directed request, you may purchase those if you wish. Otherwise, where a person who considers they may help, they are free to do so

 

[Despot91]

Sorry if I mistaken. I posted on similar topic and Fluff asked me to open a thread of my own so I did it.
If there is someone who can help it would be very appreciated as I could not figure a solution for this and if no thanks again for you time.

 

[Despot91]

Solved