automaticaly sorting a column in Excel 2

[fanch72]

Hi!
I have a table generating a column with numbers, all numbers are different. On the next worksheet I want to sort those numbers in an ascending way. I want this to be fully automatic so that the user doesnt need to press a button. Can anyone help me? Thanks a lot!
Francois

 

[GlennUK]

In the next worksheet create formulae like
=SMALL(RangeToTest,1)
in the first cell, increasing the 1 to 2 for the 2nd formula, and to 3 for 3rd, and so on, until all the figures have been retrieved from the required range, in ascending order.

Glenn.

 

[klmorgan]

You could use a pivot table and set it to sort (under advanced in field properties) and have the pivot update by a macro triggered by an action (choosing the second sheet for instance)

Regards

Keith