I have a spreadsheet in which every column updates relative to the contents of another worksheet. Several of my columns are intended to allow for a user to manually enter data that will override the contents of adjacent cells. Unfortunately, because the data on this sheet is ever changing, maintaining the relative position of any information manually imput (i.e. the manual overrides entered by users) seems to be impossible.
Is there a method by which to link manually entered data to existing data so that when the existing data changes locations, the manually entered data automatically follows the relative existing data.
Thanks in advance.
-Mike
Bookmarks