There is a range of data, A2 to Y100. At the bottom on row 100 are the totals for the columns. Several columns contain formulas from rows 2-99.
As data gets manually entered into the rows, there is a point when empty rows for entering new data are running out. If the last data entry was on, say, row 97, there are only 2 empty rows left, 98 and 99.
Everytime that happens I select row 98 + approx. 15 rows and Insert Sheet Rows to create more space for new data entry.
Since the formulas are not automatically extended to the new rows, I drag down the formulas of the columns one by one.
Is it possible to automate this process?
Say data entry reaches within 3 rows from the total, i.e. row 97. 15 new rows are automatically added, moving the totals down to row 115, and all columns with a formula get automatically copied down to row 114. Formatting of all columns is also copied down.
Data entry could proceed without the tedious need to always manually create space and copy down formulas.
Bookmarks