I am working on a project with a "customer view" that links to the "master sheet". When a customer fills out information into their sheet, the information is linked/filled into the master sheet using the linking process. I am trying to figure out how to add a row in between or delete if necessary without changing the linking information. We have found that when inserting a new row, the information changes because the row for that specific item moves, in turn changing the link to the row below it.
Is there a better way of doing this? Trying to not have to add or delete a row from both the customer view sheet and the master sheet if possible. I have explored the parent/children cells, but haven't used it in the sheet yet in hopes there are other suggestions.
Thank you!
