Hello Friends, I need a code please.

A. If anything is typed in column B (starting from B5). the code will copy the format and formulas of range (C3:J3).

And will paste it in the row that was typed in the column B row.


B. Now if the cell in column B was cleared (deleted / emptied). then the range (C?:J?) needs to be "deleted shift up".

Thanks a lot in advance!
Nawaf