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...
--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"SBX" wrote:

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