I have a worksheet that staff will enter data into each week. It is highly
likely that they will need to insert addional rows. The formulas from the
above row will need to be populated into the inserted rows and the rows below
will need to refer to the new inserted rows. Otherwise the entire spreadsheet
will fail. The formulas are in two columns which will be hidden from view and
the worksheet locked.

Is there a way that allows these two formulas to automatically be popluated
into the respective cells when an employee inserts a new row?