M
miabelladolce
how do i sort my names in excel in alphabetical order thankyou
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
B
Bernd P
M
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
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
M
Mike H
Ignore, I misread your post
Mike H said: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
R
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
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
B
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?
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?
S
smartin
BEOPS said: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?
Answered yesterday. You should be able to see the response here:
http://preview.tinyurl.com/yflmtrh
B
BEOPS
I got the answer. By a LEN function I discovered a space after some words.
Thanks
Thanks