Auto copy formulas to new row and lock cells

Hello All around the world,

I want to do:

1. copy the formulas from the previous row down when someone types into the SI Number column
2. lock the B and C column so it populates from the formula but some can't delete it or change it.

Many thanks in advance. I love this forum. Everyone is so responsive and helpful.

See attached

Jill