![]() |
#1
|
|||
|
|||
![]()
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? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
wlcdo2 | Word VBA | 2 | 06-19-2016 08:53 PM |
![]() |
dylansmith | Word | 1 | 11-06-2014 12:01 AM |
Inserting Images into a Table Cell without Moving the Text | suzan | Word | 0 | 06-27-2014 05:20 AM |
![]() |
theMikeD | Word | 2 | 09-11-2012 05:46 PM |
How do I reference a merged cell in a multi column & row table in MS Word ('03')? | jihanemo | Word Tables | 0 | 03-18-2009 08:33 AM |