Hi

I am working on a project for a client and have a problem. We have a macro
setup so that additional information can be viewed which relates to the data
in the cell (basically, the user can right-click on the cell and one of the
options is to view the additional data). We are linking to the additional
data by using named ranges.

The problem is: When data is sorted, the named range stays will the specific
cell and does not move with the data/value in the cell. The result is
incorrect association between the data and the addtional information that can
be view with the right-click option.

Is there a way to "tag" the value in a cell, so after a sort, the
association remains with the value and not the specific cell? I noticed that
comments move with the value and not the cell - but I have not been
successful with anything I have tried.

Any help would be appreciated.


Thanks
Marie