View Single Post
Old 01-08-2022, 01:29 PM
Peterson Peterson is offline Windows 10 Office 2019
Competent Performer
Join Date: Jan 2017
Posts: 130
Peterson is on a distinguished road
Default 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?
Attached Files
File Type: xlsm 02 Time and Work Log_Rebuild_05-2021_01-08-2022.xlsm (329.7 KB, 3 views)
Reply With Quote