Hi,
I wanted to know how to add a row using a macro (button in the sheet) by which the formulas in the cells above is retained in the new row. This is for the spread sheet attached. This is for if the person taking the questionnaire adds a row, the formulas put in the row 25 (in the sheet) should continue in the new row if they add a new row.