I have a sheet with sum totals and other information at the bottom.
there are currently 20 rows for data, with the totals on row 21
I would like to automatically add another row (21) to the bottom (beneath 20) when data is entered in the bottom row (20), and then again if data is added to the new row 21, making the sheet auto expanding. The new row needs to copy all formulas, formatting and conditions from the row above.
I'm guessing that this is a well solved problem, but I've no idea how to do it. Can it be done whilst expanding the range that total cells at the bottom sum to include the new values in the new rows?