how do i sort my excel worksheet in

[miabelladolce]

how do i sort my names in excel in alphabetical order thankyou

 

[Jacob Skaria]

Refer
http://www.contextures.com/xlSort01.html

If this post helps click Yes

 

[Bernd P]

Hello,

See here, please:
http://sulprobil.com/html/sorting.html

Regards,
Bernd

 

[Mike H]

Hi,

Put this code in any worksheet module and run it

Sub Sortem()
For X = 1 To Worksheets.Count
For y = X To Worksheets.Count
If UCase(Sheets(y).Name) < UCase(Sheets(X).Name) Then
Sheets(y).Move Before:=Sheets(X)
End If
Next
Next
End Sub

Mike

 

[Mike H]

Ignore, I misread your post

Hi,

Put this code in any worksheet module and run it

Sub Sortem()
For X = 1 To Worksheets.Count
For y = X To Worksheets.Count
If UCase(Sheets(y).Name) < UCase(Sheets(X).Name) Then
Sheets(y).Move Before:=Sheets(X)
End If
Next
Next
End Sub

Mike

 

[rajasekar sekar]

go Data tool-sort-select ur named column-asending-clik ok



miabelladolce wrote:

how do i sort my excel worksheet in
21-Sep-09

how do i sort my names in excel in alphabetical order thankyou

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[BEOPS]

I have posted a question on the same issue, and as I can't find it in the
forum, let me come in here. I am sorting 2 columnes according to the
instructions given in your link. However the second columne is sorted in kind
of groups. First come a-words, then some d-words, then some a-words again
(and so on). What could be the reason for this strange behaviour on the
second columne?

 

[BEOPS]

I got the answer. By a LEN function I discovered a space after some words.
Thanks