Sort row numbers assending

[John Stilwell]

I need a formula that can take a given row of numbers in one worksheet and place the same numbers in another worksheet, but in accending order. Example:

WorkSheet 1
Column: B C D E F
Row: ? 3 6 7 11 51 < RESULT


WorkSheet 2
Column: B C D E F
Row: ? 51 7 11 6 3 < Given numbers

Thanks,
John

 

[Diffy]

What I would do is copy the row. Then paste special -> transpose in another workbook. Then sort the column. Then copy and paste transpose again and you are done.