View Single Post
  #1   Report Post  
Scott Emery
 
Posts: n/a
Default Preserving cell reference after a sort

How do I preserve a reference to data when the data's cell is moved by a sort?

Example: F5 refers to M10 (either =M10 or =$M$10) and M10 contains "Domino's",
then column M is sorted and "Domino's" is moved to M15, and I want F5 now to
contain =M15 (and hence "Domino's") automatically, like when a new column is
inserted.

-Scott