I have a sheet, “Sheet1”, with several columns of data. This data is augmented regularly.
I have another sheet, “Sheet2” , that references the cells of “Sheet1”. I want “Sheet2” to maintain it’s references to the cells not the cell data of “Sheet1”
However, when I add a new row to “Sheet1” the references shift down one cell, maintaining their reference to the data that they were initially assigned to.
I want the reference on “Sheet2” to continue to reference cell “Sheet1”.A1 not "Sheet1.A2 after I add a new row to “Sheet1”.
Protecting the column and protecting the sheet do not accomplish this condition.
Is this possible in Calc?