Sort a row of data alphabaticaly to another colum

[drag-driver]

My problem is as follows: I have a row which has alist of products which i want to put in a new sheet in alphabatical order. I want this to be done automaticaly when i change the name of a product in th row that it places it in the right place in the colum list in another sheet. I would prefere not to have to use the sort feature in excel as i dont want the user to do anything only update the products in the row.

 

[Aladin Akyurek]

On 2002-04-12 03:17, drag-driver wrote:
My problem is as follows: I have a row which has alist of products which i want to put in a new sheet in alphabatical order. I want this to be done automaticaly when i change the name of a product in th row that it places it in the right place in the colum list in another sheet. I would prefere not to have to use the sort feature in excel as i dont want the user to do anything only update the products in the row.

Is the input range fixed or changing?
This message was edited by Aladin Akyurek on 2002-04-12 15:10