When inserting row in table, how do I adjust cell reference to new row
I use a spreadsheet to track task time of chronologically successive tasks. The Start time cell in a given task row references the Stop time cell in the prior row, e.g., C6 (Start) = D5 (Stop).
When a new row is manually inserted between existing rows, in the row below it, the Start value should reference the Stop cell from the newly added row, e.g., C11 = D10. But the reference remains to the Stop value that is now above the new row, e.g., C11 = D9.
I've tried to get this to work but haven't been successful, due to other macros in the spreadsheet, which I've attached.
How can I get the Start cell below the newly added row to reference the Stop cell in the newly added row?
|