I have a spreadsheet that has two sheets. One takes entries and a second manipulates content from the first and displays results.
If I remove or add a row, the references in sheet two change, killing the desired content in that same sheet. If I delete row two from sheet one, what becomes row two in sheet one does not replace the content that was in sheet two, instead the cell breaks, referencing a non-existent or irrelevant cell.
I know what's happening. Instead of referencing a position relative to the sheet, it's referencing the actual cell, but not only does that not make sense, it doesn't work for my intended purpose.
Can I change this functionality or is there a better way to approach the issue?