Sort a row of data alphabaticaly to another colum

drag-driver · Apr 12th, 2002, 04:17 AM

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 · Apr 12th, 2002, 04:08 PM

Quote:

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 04:17 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	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.