Well, you could do it by formulae, or you could have a macro that did
it automatically when one of the values change. Either way, you would
need to give further details if you wanted a more specific answer.

Pete

On Mar 26, 10:13 am, Mats wrote:
I would like to sort automatically (not manually) the values in 10 different
cells and when the values change the order of the cells automatically
change.....and so on...

Do this manually is no worries but....automatically...?