I work for a recovery center and we have a lot of collaborative sheets. We have a master discharge list that we have functioned to bring data over from another sheet as well as filter it by different columns if we wish to do so. It all worked great until we decided to add a new column. Now all of the comments are no longer aligned with the correct cells.
My question is, how can I keep comments aligned to a certain cell no matter how we move them?