Reply to thread

Message: <blockquote data-quote="carolgb" data-source="post: 1803439" data-attributes="member: 400776">Glad its been useful. Definitely an annoying bug. Im happy to know about this technique anyway. It makes it easier to globally update pop-up cells with a modified list without having to fuss over restoring the target cells original values. Before, when updating by pasting an updated pop-up cell into a target cell, this would overwrite whatever element of the list was already there (unless the value of the source cell was already the same as the target cell). Now, it updates the list of a cell while preserving the value already there. If the value of the cell is not in the list youre replacing it with, it simply adds the new value to the list.</blockquote>