Formula cell references when sorting values in another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Formula cell references when sorting values in another worksheet
I have a formula that uses values from another worksheet. I need to sort that other worksheet numerous ways to find specific data. Once I have found and arranged the necessary data together I am creating a formula (being careful not to use ranges, but individual cell addresses) so that when I sort the list some other way, the formula will adjust accordingly (basically follow the "values" to where ever they may have moved to). I am very familar with absolute and relative cell references, and they seem to have no effect on the values in the other worksheet. I have carefully studied help, FAQ's and the like to no avail, PLEASE HELP!
 
Hi
AFAIK there's no chance to achieve this. Neither with using relative or
absolute references. Formulas are only attached to cells and not to
values. So then you sort one list the formulas would not change
 
Back
Top