Hello,

I have a sheet that has rows of data, in which they are not in a table. There are formulas within the rows, and currently we manually insert a row so the formulas copy to the newly inserted row.

I would like to automate this process. The issue I'm posed with is that the row numbers are variable and change as new records are entered. Below is a snipit of the sheet. The intention is to insert a row about the green line, but as the new data is inserted the row number will change.

I have a sheet that has rows of data, in which they are not in a table. There are formulas within the rows, and currently we manually insert a row so the formulas copy to the newly inserted row.

I would like to automate this process. The issue I'm posed with is that the row numbers are variable and change as new records are entered. Below is a snipit of the sheet. The intention is to insert a row about the green line, but as the new data is inserted the row number will change.