Hi Dangelor,

I used the above code but it groups the newly inserted rows since the row where it copies the formula is grouped.
This cannot be ungrouped by the user as the worksheet is protected.
Please refer to the original file I have attached and the macro does not group the new insertion .

Appreciate if you can tweak it.

Thanks