Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2022, 01:29 PM
Peterson Peterson is offline When inserting row in table, how do I adjust cell reference to new row Windows 10 When inserting row in table, how do I adjust cell reference to new row Office 2019
Competent Performer
When inserting row in table, how do I adjust cell reference to new row
 
Join Date: Jan 2017
Posts: 129
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, 1 views)
Reply With Quote
  #2  
Old 01-16-2022, 01:06 PM
Peterson Peterson is offline When inserting row in table, how do I adjust cell reference to new row Windows 10 When inserting row in table, how do I adjust cell reference to new row Office 2019
Competent Performer
When inserting row in table, how do I adjust cell reference to new row
 
Join Date: Jan 2017
Posts: 129
Peterson is on a distinguished road
Default

I solved this by re-applying the column's formula to the entire column when a row is added, which is detected via Worksheet_Change for a separate column.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
When inserting row in table, how do I adjust cell reference to new row Reference Word Table Cell Using Offset? wlcdo2 Word VBA 2 06-19-2016 08:53 PM
When inserting row in table, how do I adjust cell reference to new row how adjust cell width manually when table extends beyond paper margins? 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
When inserting row in table, how do I adjust cell reference to new row Inserting a date calculated from a table cell 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft