Sorting Values Without Sorting Formulas

[SBX]

Is there a way to sort values from several rows that were calculated using
formulas without disturbing the sequence of the formulas?

After the sort I would like for the formulas to be in the same place before
the sort and I would also like for th sorted values to be recalculated from
the formulas that remained in sequence.

Thanks in advance

 

[Sheeloo]

That is the default behavior...
To test
Enter some data in Col A then enter
=A1
in B1 and copy down

Sort on Col A & B...
Change some values in Col A and see...

 

[SBX]

Thank you very much. This was very helpful.

That is the default behavior...
To test
Enter some data in Col A then enter
=A1
in B1 and copy down

Sort on Col A & B...
Change some values in Col A and see...