Auto sort alphabetically

[diksha_16]

Is there a way to auto sort alphabetically in excel? For example, if I have a list to which I have to keep adding items on a daily basis, is there a command which can help auto sort the new entries everytime I enter them.

[JohnTopley]

You will need VBA to do this.

[alansidman]

Put this code in the worksheet change event for the sheet in question. This also assumes that the data to be sorted is in Column A. You may need to change up the range to meet your particular needs. Since you did not attach a sample worksheet, this is the best I can do under the circumstances.

Please Login or Register  to view this content.

[diksha_16]

I am sorry but I did not understand where I have to enter this code. Attached is the worksheet, under sheet Item List, I need to make sure data is automatically sorted.

[JohnTopley]

Please Login or Register  to view this content.

Right click on "Item List" tab ==>View Code++> copy/paste code (Done in Attached)

Now enter data in column B

[diksha_16]

I wanted to sort data from column A, row 2. Also I tried adjusting the code, but it did not work. After entering the data, do I need to give a command for it to work?

[JohnTopley]

You want to sort by CODE not Description ?

[diksha_16]

You want to sort by CODE not Description ?

Yes by code

[JohnTopley]

Try

Please Login or Register  to view this content.

[alansidman]

Amended John's first Code. Open your file, click on Alt +F11. In the properties window on the left, double click on Sheet3. Insert the code. It will automatically sort when you put in data in column A.

Please Login or Register  to view this content.

Edit: John, I believe the target column should be 1 and not 2.

[diksha_16]

Still not working, not sure where I am going wrong. Please see attached under 'Item List' sheet

[JohnTopley]

No code: did you follow Alan's instructions ??

Code added (again) to attached.

[diksha_16]

I did add the code...not sure what happened. It works now though. Thank you very much!