Problem with sorting

[Christoffer_Col]

I have one worksheet with names in A1, A2 and A4 and corresponding numbers in B1, B2 and B4.

How do I transfer the rows containing text/numbers (1,2,4) to another sheet and sort them in alphabetic order automatically without using the "Sort Ascending/Descending button" in the new sheet?

For instance if I enter some text in A6 and a corresponding number in B6 I want that row to immediatelly be transfered to the other sheet and inserted in respect to its alphabetical order.

In other words:

Bill 76
John 85
(blank)
Chris 59


Should be (in the other sheet):

Bill 76
Chris 59
John 85

Is this possible to do without VBA?

[martindwilson]

http://www.dailydoseofexcel.com/arch...-text-sorting/

[snasui]

Try this,

C1

Please Login or Register  to view this content.

Enter and copy down.

G1

Please Login or Register  to view this content.

E1

Please Login or Register  to view this content.

Enter and copy down.

F1

Please Login or Register  to view this content.

Ctrl+Shift+Enter and copy down.

See attached file.

[Christoffer_Col]

Thank you very much, it solved my problem and I learned from it also.