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