locking row to the top
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from the form always appear above it. Just having the row appear at the bottom wont work for me as I want formulas in the top locked row to automatically fill in the new rows from the sheet. Having a column formula wont work either as I want the user to be able to edit the data at any time and column formulas wont allow that.