sorting columns with formulas

[still learning]

How do I sort columns, which have data that is being used in formulas in a different column, without any of the values changing after sorting?

[Peo Sjoblom]

Only way I know of would be to turn the formulas into values by copy and
paste special as values


Regards,

Peo Sjoblom

"still learning" wrote:

>
> How do I sort columns, which have data that is being used in formulas
> in a different column, without any of the values changing after
> sorting?
>
>
> --
> still learning
> ------------------------------------------------------------------------
> still learning's Profile: http://www.excelforum.com/member.php...o&userid=23900
> View this thread: http://www.excelforum.com/showthread...hreadid=375767
>
>