Hi

Excel worksheet functions by definition can't do this. In Excel, a function
can't change anything on sheet.

You have to use a macro, started by means of keyboard shortcut or button. Or
you have to write a Change event for worksheet.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Rahul" wrote in message
...
Hi,

Is there a sort function in excel? I want to do excatly the same stuff
that
the Sort Menu command does but want a worksheet function for that.

The point is I already have Col A with categories and Col B with
Numerical
Values which I want to sort by. (the result sorted goes to cold C and D
say...)

Its irritating to do a manual sort everytime some value in Col B changes!

Any ideas?

Thanks!

-Rahul