Hi
Is there a way to permanently maintain a link between 2 (or more) cells.
In the attached file there is a table with "Name" and associate "Criteria" and a separate "Totals" table which (in my work book) would be updated on an ongoing basis.

My problem is that because a persons "Totals" cell value contributes to a yearly data set I want to be able to maintain the "Totals" for each person even if they are no longer (have been removed from) the "Name" list.

Ideally, I would like to be able to automatically move any "have been removed" names to an area below the main "Name" etc table.



Regards.

Attached Files

demo.xlsx (11.7 KB, 9 views)

Perhaps Copy-Paste Special - Values?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for the reply Pecoflyer
The paste values idea will help in moving a whole persons row.

My concern is that the way I currently have the tables organized it would be possible to change a name and have the new/moved name get the totals from another person.

This is why I had the idea of "somehow" linking a persons total to that persons name so when they are moved the total goes with them. Unfortunately, I have no idea of where to start to achieve this.

Is it possible to format some rows to only allow the insertion of new data and forbid the removal of any/all existing info? This solution would require the table to be filtered/organised each time a new name and criteria is added to the table, can excel be set to automatically filter a table?

Regards.