Macro for inserting a new ROW based on a condition

I have come across a requirement wherein a new row shall be inserted if a set of criteria are met. I would like to get the same done with the help of a button when clicked will run the MACRO.

I have briefly elaborated in the excel spreadsheet attached here with. Please support.

Many thanks in advance.

Conditions / Criteria :

1. If COLUMN "I" (Bal Qty.) = 0, then COLUMN "H" (Ship Qty.) should be made equal to COLUMN "G" (Quantity)

2. If COLUMN "I" (Bal Qty.) <> 0, then COLUMN "H" (Ship Qty.) should be made equal to COLUMN "G" (Quantity), check IF COLUMN "D" (Concatenate) has duplicate line item, IF YES, a new line needs to be inserted and value of COLUMN "I" (Bal Qty.) from the previous row should be inserted into COLUMN "G" (Quantity)

3. Insert a formula in COLUMN "I" (Bal Qty.) to be Column "G" (Quantity) - Column "H" (Ship Qty.) and will be applicable for all rows.

The above condition will be applicable for all the rows in the spreadsheet. I hope I was able to clarify my requirement.