I am trying to sort data in one sheet (Records), but not have it affect the cells in a second sheet that converts two cells from numbers to text (from the first sheet) and then concatenates them as in the following:

=CONCATENATE(TEXT(Records!C2,0),"-",(TEXT(Records!D2,0)))

I want this cell in the second sheet to remain relative to the other column cells in this sheet (which is a pre-sorted version of the first sheet) and not relative to the post-sorted data in the first sheet (Records).

Hope I'm making my question clear!

Thanks for anyone's help.