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)