insert row with the formula and borders before or after item based on inputbox user

[MKLAQ]

hello

I need macro to insert row based on using two inputboxes(before,after)

first should show "before inputbox " when write the item based on column B should insert row before the item with the same borders , formulas and if there is any cell is empty or contain formula ,then should show hyphen as in sheet RES3 when write CR-CCR-1 into inputbox user. and if there is duplicate items when insert row should ignore them and should be before first row for duplicate item .

second if I press cancel or close or ok "before inputbox" then should show "after inputbox" when write the item based on column B should insert row after the item with the same borders , formulas ,if there is any cell is empty or contain formula ,then should show hyphen as in sheet RES2 when write CCR-2 into inputbox user and if there is duplicate item when insert row should ignore the others and should be after first row for duplicate item

finally if I don't write any thing into "before inputbox " or "after inputbox" should insert multiple rows at once after last row for each item in column B based on on column A as in sheet RES1 and add the formula by summing the values .the column A when insert multiple rows for each item depends on beginning of the item and finish until the empty last row for this item and should not change its place into cell when insert row whether insert row before or after . with considering the columns and rows will increase every time with the same structure then when insert row with formula,borders should finish until for any column or row contain values , if I run the macro again should replace data because the data it will increase every time into sheet MONTHLY


NOTE : all of the condition should implement in sheet MONTHLY
thanks in advance