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

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

If this post helps click Yes
---------------
Jacob Skaria


"miabelladolce" wrote:

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

Hello,

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

Regards,
Bernd

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 Befo=Sheets(X)
End If
Next
Next
End Sub

Mike

"miabelladolce" wrote:

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

Ignore, I misread your post

"Mike H" wrote:

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 Befo=Sheets(X)
End If
Next
Next
End Sub

Mike

"miabelladolce" wrote:

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

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/tutorials...l-view-vi.aspx

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?
--
BEO


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"miabelladolce" wrote:

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

BEOPS wrote:
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 he

http://preview.tinyurl.com/yflmtrh

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


"smartin" wrote:

BEOPS wrote:
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 he

http://preview.tinyurl.com/yflmtrh
.