how to sort 2 column

[dk-iceman]

Hi there

How do I sort 2 columns when there are funktions (i think itīs called) in the cells ... it f*ck up result

1 column is text from other cells, and the second column is numbers (=b3+g4 ) and so on

Iīve tryed the makro recorder but same result ...

Please help

dk-iceman

[WinteE]

Hi dk-iceman,

Copy the entire sheet to a new sheet with paste values and sort on this new sheet. All can be recorded to a macro.

Erik