automatic sort

[haplo39]

I have an index, for example 100 rows and 5 colums (A to E), when i add new row i want excel to put the new row in an alphabetical order according to column A automatically without creating list. also it will sort the other 4 colums accordingly.

[stevebriz]

you can try this:

Please Login or Register  to view this content.

[haplo39]

it works but not enough, it doesn't sort automatically, when i run the macro it sorts.

[stevebriz]

Put this in the spreadsheet code:

Please Login or Register  to view this content.

[j0e_16]

I would like to sort Column B In Alphabetical Order. From A-to-Z automatically.

Column B C D E F G H I J K L M N O
John Smith x x 0
Don Cambrain X X X

I would also like information in C D E F G H ......, to move up and down with the name in colum B WHen it is listed in alphabetical order

So it would switch to
Don Cambrain X X X
John Smith x x 0

I know i am asking a lot, but i really need this. it would save me some time. Thank you soo much.

COLUMN B starts at B2 and ends at B236
Row 2 across to AG contains information

I am very new to excel a beginer, probably rate myself 2 outta 10. WHen providing instructions please go into detail so a begginer can follow along. Like where to go to place the forumla etc,....

Thank you soo much anyone who helps out.