Need help with either Conditional formula or VBA script to solve issue

[Austin18765]

Hello I am having an issue figuring out how to get my duty excel spreadsheet to do the below and am looking for either a formula or VBA based solution:



Basically I have the below spreadsheet and if there is a value in the additional duty column (starting at I5) I would like the value to be pulled or copied into M15 then the corresponding value in b5 pulled into L15, D5 pulled into N15, and C5 pulled into O15. Then I need the value in H5 pulled into M16, and then the corresponding value in b5 pulled into L16, D5 pulled into N16, C5 pulled into O16. But if there is no value in I5 I need only the value in H5 pulled into M15, and then the corresponding value in b5 pulled into L15, D5 pulled into N15, and C5 pulled into O15. I need this to happen for each row of the duty calculation table under the information pulled from the previous row. There will always be a value in the actual duty column (H), but the value in the additional duty is conditional so it is more often then not empty. Thanks so much for any help! I am pretty new to excel and would normally try to figure this out myself but I am stuck. Again thanks so much for any help!