How do I insert or delete a row in between rows that have links and it not affect the links?
I am working with a "customer view" and a "master sheet". This sheet allows the customer to only see certain information and update it and the links add the information to the master sheet.
We need to insert rows at times as well as delete rows, but currently when we do this the links stay with the cell/row, but the information moves down causing the entire sheet to be incorrect from that row down. Is there a way to insert or delete a row and for the links to continue to match on both sheets?
Help Article Resources
Check out the Formula Handbook template!