Hi Rylo

Thanks for the code. Is is certainly faster. Just one hurdle to cross. The Data Input - Sheet is fully protected but permits
data entry only in specific range. The new rows which are created are locked. My earlier macro did have not this issue.
Maybe when the formula copies, it should copy the formats as well and this could help,
Can you tweak the code?

Thanks